Funny thing about <Ctrl> Z

[BMD]

It quit working. If I make a change to the sheet and wish to undo it I just hit Ctrl Z, but it quit working. How do I turn it back on?

 

[Von Pookie]

Do you have a macro making the change on the sheet? Or a Worksheet_Change macro that runs on that sheet?

You can't undo anything directly after a macro runs.

 

[BMD]

I did not know I have two macros, one on ThisWorkbook Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
and one on sheet 17
Sub Worksheet_Change(ByVal Target As Excel.Range)

 

[Von Pookie]

Yep, that would do it, depending on how the macros are coded.

Workbook_SheetChange will run whenever a change is made on any sheet in the workbook unless specified within the macro code.

So when you make a change on the sheet, that macro triggers and wipes out any chance you had of undoing anything up until that point.

I think this only happens with macros that are affecting the sheets in some way, though. For example, if I run a macro that does nothing but display a message box, I am still able to use 'undo'. But if I run a macro that puts a value in cell A1, the undo arrow becomes grayed out.