software

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?

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

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

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

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

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

--

Dave Peterson


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: www.excelforum.com/member.php...oamp;userid=29327
View this thread: www.excelforum.com/showthread...hreadid=496622Not that I know. In fact, mode code kills the undo stack.

fabiospark wrote:
gt;
gt; Code:
gt; --------------------
gt; But lots of things in excel kill the undo stack (running most macros for
gt; instance).
gt; --------------------
gt;
gt; Isn't there any way to prevent the killing?
gt; With some piece of code, maybe...?
gt;
gt; --
gt; fabiospark
gt; ------------------------------------------------------------------------
gt; fabiospark's Profile: www.excelforum.com/member.php...oamp;userid=29327
gt; View this thread: www.excelforum.com/showthread...hreadid=496622

--

Dave Peterson

mode code = most code

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

Dave Peterson wrote:
gt;
gt; Not that I know. In fact, mode code kills the undo stack.
gt;
gt; fabiospark wrote:
gt; gt;
gt; gt; Code:
gt; gt; --------------------
gt; gt; But lots of things in excel kill the undo stack (running most macros for
gt; gt; instance).
gt; gt; --------------------
gt; gt;
gt; gt; Isn't there any way to prevent the killing?
gt; gt; With some piece of code, maybe...?
gt; gt;
gt; gt; --
gt; gt; fabiospark
gt; gt; ------------------------------------------------------------------------
gt; gt; fabiospark's Profile: www.excelforum.com/member.php...oamp;userid=29327
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=496622
gt;
gt; --
gt;
gt; Dave Peterson

--

Dave Peterson