UNDO - not available

[Chris T-M]

I have a 1 MB Excel Workbook where UNDO icons and menus are greyed out and
unavailable. I know Excel has limits on what it will UNDO, but I just tested
it by typing an X in a cell. The UNDO icon highlights until I leave the cell,
and then I can't UNDO any longer.

Any ideas how to turn UNDO back on?

 

[Mike H]

Hi,

Maybe you have some worksheet change code that executes when you type in a
cell?

Try opening your workbook with macros disabled and see if you get it back
then.

Mike

 

[Chris T-M]

Yep! Got it back. Now I just have to search code, but that's much easier than
where I was at. Thanks for the insight.

 

[RJ27]

I have exactly the same problem, but there are no macros. I have changed the
macro security settings, but the problem persists. I think it started after
a recent autoupdate. Does anyone have any other suggestions for a fix?
thanks
Richard