I have a button assigned to a macro. Is it possible to undo that macro once
you have pushed the button?

Adam

no, not unless you build your own undo stack. Basically, a macro can carry
out numerous actions and I guess Excel just doesn't keep a track of them
and, in fact, resets the undo stack.

Regards

Trevor


"Adam" wrote in message
...
I have a button assigned to a macro. Is it possible to undo that macro once
you have pushed the button?

Most actions performed by an macro can not be undone - in fact, most macro
instructions clear the undo history so any previously available undo's are
cleared/lost.

--
Regards,
Tom Ogilvy


"Adam" wrote in message
...
I have a button assigned to a macro. Is it possible to undo that macro
once
you have pushed the button?

Try saving the original state of the workbook/sheet as the
first step in the process, then you can offer your own
undo feature.

Tony


-----Original Message-----
Most actions performed by an macro can not be undone - in
fact, most macro
instructions clear the undo history so any previously
available undo's are
cleared/lost.

--
Regards,
Tom Ogilvy


"Adam" wrote in message
...
I have a button assigned to a macro. Is it possible to
undo that macro
once
you have pushed the button?


.