Undo macros

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" <Adam@discussions.microsoft.com> wrote in message
news:657CA706-3613-460C-89E5-8465BDF82073@microsoft.com...
>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" <Adam@discussions.microsoft.com> wrote in message
news:657CA706-3613-460C-89E5-8465BDF82073@microsoft.com...
> 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" <Adam@discussions.microsoft.com> wrote in message
>news:657CA706-3613-460C-89E5-8465BDF82073@microsoft.com...
>> I have a button assigned to a macro. Is it possible to
undo that macro
>once
>> you have pushed the button?
>
>
>.
>