Why can't I undo forever in Excel like in Word?
 

When I am working in Word, I can undo as manny actions as I have performed,
as long as I don't save the actions. However, in Excel, I can only go back
a few steps. How can I go back in actions like I do in Word?

Why can't I undo forever in Excel like in Word?
 

You can change the level of undo's in Excel:

xl2k and above
XL: How to Modify the Number of Undo Levels
http://support.microsoft.com/?kbid=211922

xl97
XL97: How to Modify the Number of Undo Levels
http://support.microsoft.com/?kbid=162944

But lots of things in excel kill the undo stack (running most macros for
instance).

SamWL wrote:

When I am working in Word, I can undo as manny actions as I have performed,
as long as I don't save the actions. However, in Excel, I can only go back
a few steps. How can I go back in actions like I do in Word?

--

Dave Peterson

Why can't I undo forever in Excel like in Word?
 

Code:
--------------------
But lots of things in excel kill the undo stack (running most macros for
instance).
--------------------


Isn't there any way to prevent the killing?
With some piece of code, maybe...?


--
fabiospark
------------------------------------------------------------------------
fabiospark's Profile: http://www.excelforum.com/member.php...o&userid=29327
View this thread: http://www.excelforum.com/showthread...hreadid=496622

Why can't I undo forever in Excel like in Word?
 

Not that I know. In fact, mode code kills the undo stack.

fabiospark wrote:

Code:
--------------------
But lots of things in excel kill the undo stack (running most macros for
instance).
--------------------

Isn't there any way to prevent the killing?
With some piece of code, maybe...?

--
fabiospark
------------------------------------------------------------------------
fabiospark's Profile: http://www.excelforum.com/member.php...o&userid=29327
View this thread: http://www.excelforum.com/showthread...hreadid=496622

--

Dave Peterson

Why can't I undo forever in Excel like in Word?
 

mode code = most code

(No, I don't have a code, er, cold!)

Dave Peterson wrote:

Not that I know. In fact, mode code kills the undo stack.

fabiospark wrote:

Code:
--------------------
But lots of things in excel kill the undo stack (running most macros for
instance).
--------------------

Isn't there any way to prevent the killing?
With some piece of code, maybe...?

--
fabiospark
------------------------------------------------------------------------
fabiospark's Profile: http://www.excelforum.com/member.php...o&userid=29327
View this thread: http://www.excelforum.com/showthread...hreadid=496622

--

Dave Peterson

--

Dave Peterson