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

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
"YvonneD" wrote in message
...
|I have a user who somehow has disabled the undo in a spreadsheet.

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
"YvonneD" wrote in message
...
|I have a user who somehow has disabled the undo in a spreadsheet.

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
"YvonneD" wrote in message
...
| 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
| "YvonneD" wrote in message
| ...
| |I have a user who somehow has disabled the undo in a spreadsheet.
|
|
|

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...;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

On Tue, 8 Feb 2005 11:13:03 -0800, "YvonneD"
wrote:

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
"YvonneD" wrote in message
...
|I have a user who somehow has disabled the undo in a spreadsheet.