PDA

View Full Version : Solved: After a macro or code is run the undo function doesn't work.



blastpwr1970
06-20-2006, 09:43 PM
Hi,

After a macro or code is run the undo function doesn't work.

Does anybody have a good explanation for this or a solution to undo the macro.

:reading:
Thank's
Julio

Jacob Hilderbrand
06-20-2006, 10:34 PM
Well, after the macro runs, the Undo feature would have to Undo the effects of the macro first, which it can't do, so Undo is not available.

You could create your own Undo code, but would probably be more trouble than it is worth.

If Undo is really needed, you will need to look at when your macros are called, and if some of those calls are not needed.

Jan Karel Pieterse
06-21-2006, 05:28 AM
I have a couple of pages about creating a VBA undo system:

www.jkp-ads.com/articles/undowithvba00.asp (http://www.jkp-ads.com/articles/undowithvba00.asp)

blastpwr1970
06-23-2006, 09:44 AM
Thank's