Undo Won't Work

[tlc53]

Hi there,
The spreadsheet I am working on contains more than 50 sheets and has various VBA code.
I noticed recently that Undo has stopped working and I'm not sure why. Possibly it has something to do with a VBA code, but I wouldn't know where to start. It was running fine for a long time.
For example, if I entered text in a cell and enter, Undo is not option.
Any idea why this is happening and how I can prevent it?
Thanks!

 

[JLGWhiz]

You can check in the File>Options>Advanced and see if Undo has been turned off for a large file size, and if your file exceeds the limit, then that is probably the cause.

 

[Michael M]

If you have a code in the worksheet that is triggered when data is entered......the UNDO stack is cleared on running any macro.

 

[tlc53]

If you have a code in the worksheet that is triggered when data is entered......the UNDO stack is cleared on running any macro.

Thanks. It doesn't matter what sheet I am on, the Undo is not an option. Even on sheets with no VBA code associated with it. I assume that means code is running if data is entered on any sheet, rather than when the sheet is active. I thought it may be a Calculate coding (like below) but I have ensured it is referring to a particular worksheet. Any idea what to look for, to find the code that is running every time data is entered and hence, stopping my Undo from working?

Private Sub Worksheet_Calculate()

    If ThisWorkbook.Sheets("E1").Range("V6").Value = 74 Then
        ThisWorkbook.Sheets("E1").Shapes("Check Box 11").Visible = True
    Else
        ThisWorkbook.Sheets("E1").Shapes("Check Box 11").Visible = False
    End If
    
End Sub

 

[tlc53]

You can check in the File>Options>Advanced and see if Undo has been turned off for a large file size, and if your file exceeds the limit, then that is probably the cause.

I couldn't find the Undo option in this area?

 

[Michael M]

It's in the data section, 3rd last on the page....mine defaults to 8Mb file size !!

 

[tlc53]

It's in the data section, 3rd last on the page....mine defaults to 8Mb file size !!

Thanks. Found it. Mine also defaults to 8MB. My file is only 1,712KB, so that's not the issue.

 

[Michael M]

Does the problem go away when you open Excel in safe mode (hold down control key when you start Excel)?

AND this from Microsoft

I finally found the answer to my problem with the "undo" and "redo" no longer working in Excel.  Apparently the registry entry which determines the number of undo steps for Excel had somehow gotten changed to zero.

The below link explains how to correct the problem.

http://support.microsoft.com/kb/211922']http://support.microsoft.com/kb/211922

 

[tlc53]

Does the problem go away when you open Excel in safe mode (hold down control key when you start Excel)?

Yes, in safe mode the problem goes away and Undo/Redo are available

 

[Michael M]

Ok, so if you go to file>>options>>Trust Center>>Trust center settings>>Macro settings>>check the disable ALL macros.
Save>>Close>reopen does it work for you ?
If it does you have a macro firing, possibly from your personal.xls file....you need to track down the one causing the issue.
Can you upload the workbook to a hosting site, llike dropbox, so we can maybe help track down the problem ??