There are lots of things that can kill the undo stack.

Running non-trivial macros, doing a save.

I don't think you can do anything about changing excel's behavior.

On the other hand, if you're the one writing the macros, you could create an
undo for what your macro did.



Padjo wrote:

Undo button fades after a few minutes and can't undo last entry.
How can I fix this?
Many Thanks.

--

Dave Peterson