Undo Stops Working

[Big Bruiser]

I am using Excel 2007 and occassionally my undo button will clear its memory and will be greyed out. Therefore, it will not let me undo some of the simplist tasks.

I do not know what triggers the undo to stop working. I would like it so it never does this.

Let me know if I can explain this any better.

I would appreciate any help!

 

[Excel_Wizard]

Hey There Big Bruiser...glad you joined.

Try saving and closing your Excel file, then re-opening in "Safe Mode."

I am assuming you are running VBA in the model, and the macros are disrupting the redo/undo functionality. "Safe Mode" disables the macros...check to see if you can undo/redo then check back...there are some other steps once determining what the issue is....

 

[MrKowz]

I am using Excel 2007 and occassionally my undo button will clear its memory and will be greyed out. Therefore, it will not let me undo some of the simplist tasks.

I do not know what triggers the undo to stop working. I would like it so it never does this.

Let me know if I can explain this any better.

I would appreciate any help!

Does the file have any macros in it? To check this, press ALT+F11 to bring up the VBA editor and see if there are any modules in your workbook. Also, double click on each worksheet in the editor to see if there is code in any of the worksheets.

Any time a macro runs, it clears the Undo/Redo cache.

 

[Big Bruiser]

Hey guys, yes the file has macros and my undo cache is cleared when I run the macro. However, if I have macros enabled, even if I don't run the macro, occassionally my cache gets cleared. How do I stop it from doing this or do I need to keep macros disabled while I work on files?

Thanks

 

[MrKowz]

Do you have any Worksheet_Change macros that might be firing when you edit a cell? The cache shouldn't be clearing unless some code is ran.

 

[MikeToon]

Do you have any Worksheet_Change macros that might be firing when you edit a cell? The cache shouldn't be clearing unless some code is ran.

That's the answer... somewhere along the line you have a Worksheet_Change event that is firing and trashing that "Undo"... I struggled for hours to get this right...

Hope this helps someone else....

Peace out....