User disabled undo in excel

[Guest]

I have a user who somehow has disabled the undo in a spreadsheet.

 

[Jim Rech]

That's odd. You mean if he types something in a cell and immediately
presses Ctrl-z it doesn't disappear?

 

[Guest]

Thats right. Can for the life of me figure what he did.

 

[Jim Rech]

The only thing I can think of is that the undo buffer is cleared whenever a
macro makes a change. So if a macro were running in this workbook whenever
an entry was made it could have this effect. A quick way to check this
would be to disable macros when the workbook is opened (assuming Security is
set to Medium or higher). Of course if the workbook has no macros (and no
other open workbook has macros) then this is not it.

--
Jim Rech
Excel MVP
| Thats right. Can for the life of me figure what he did.
|
| "Jim Rech" wrote:
|
| > That's odd. You mean if he types something in a cell and immediately
| > presses Ctrl-z it doesn't disappear?
| >
| > --
| > Jim Rech
| > Excel MVP
| > | > |I have a user who somehow has disabled the undo in a spreadsheet.
| >
| >
| >

 

[Gord Dibben]

Yvonne

If no macros being run..........

Could user have been mucking about in the Registry and changed the number of
undo levels to 0?

Check out this KB Article on this subject.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q211922

I can, by editing the Registry, reduce my undo levels to 0.

Using Win XPPro and Excel 2002.


Gord Dibben Excel MVP