R
Richard
When I disable this code the undo/redo buttons work. Why?
Can it be changed?
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal
Target As Excel.Range)
Application.EnableEvents = False
On Error GoTo ws_exit
If Not Application.Intersect(Target, Range("a:i")) Is
Nothing Then
Target(1).Value = UCase(Target(1).Value)
End If
Range("G2").Value = Date
ws_exit:
Application.EnableEvents = True
End Sub
Can it be changed?
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal
Target As Excel.Range)
Application.EnableEvents = False
On Error GoTo ws_exit
If Not Application.Intersect(Target, Range("a:i")) Is
Nothing Then
Target(1).Value = UCase(Target(1).Value)
End If
Range("G2").Value = Date
ws_exit:
Application.EnableEvents = True
End Sub