VBA code disables "UNDO" function on spreadsheet

[toolman_dustin]

This code is running in the "code module" for a specific worksheet.

Problem: Something in the code disables the worksheet UNDO feature for the entire worksheet.
The worksheet name is "Alerts".

Is this normal or can I modify the code somehow to regain access to UNDO?

thanks,
Dustin

Please Login or Register  to view this content.

[mehmetcik]

You cannot use undo to undo the affects of a Macro.

Save your data before you run the macro.

[toolman_dustin]

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

[toolman_dustin]

mehmetcik,

thanks for the reply. I know I can't undo the affects of the macro, however, the entire spreadsheet "undo" feature is disabled. The Macro only addresses column's E, W & X.

Undo for all other columns are disabled. Is this a normal byproduct of the ByVal command?

thanks.

[TMS]

Is this a normal byproduct of the ByVal command?

No, it's just what happens when you run a macro. It "kills" the undo stack. I guess the theory is/was that a macro can make hundreds, if not thousands, of changes, and it is unrealistic to expect that you can undo the effect of a macro.

Can't quite see why you are using a Change event handler for what is, essentially, Conditional Formatting ... which wouldn't give you the issue.


Regards, TMS