Hi
Pretty new to this forum and to excel programming, so forgive me if I'm doing wrong here.
Well, created a macro for recording the date for changes in cells, now the UNDO function won't work whenever I change something in those cells.
The code used to record is:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("a:m")) Is Nothing Then
Cells(Target.Row, 14) = Date
End If
End Sub
Is there anyway to go around the macro not allowing the undo function to work.
Thank you for your time.
Bookmarks