I have a macro-enabled sheet that was working fine.
Then I saved, and repoened and was repaired.
Then some print option was removed...
and now I can't UNDO steps on my spreadhseet.
my VBA works with active cell, not sure if that has anything to do with it.
Yes, the use of ACTIVE macros that are constantly updating things in the background can and usually does remove the UNDO stack.
And before you ask, the workaround is to not have active macros in the background running all the time, change your macros into on-demand macros, so you only lose your UNDO stack when you manually activate your macros.
Last edited by JBeaucaire; 04-02-2017 at 06:51 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Any action by a macro that changes the environment (a cell value, a format, a range name, most anything you can think of) flushes the Undo buffer.
Entia non sunt multiplicanda sine necessitate
Whenever you run a macro it kills the undo stack.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks for the response so how do you guys think I can get this work?
Please Login or Register to view this content.
Last edited by JBeaucaire; 04-02-2017 at 07:49 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.
You can't retain this functionality and have an UNDO stack.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks