Hi Mike,

Look he

http://j-walk.com/ss/excel/tips/tip23.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mike Archer" wrote in message
...
Hello. I am trying to figure out if the condition of a worksheet or
workbook
can be captured prior to running a macro so that the results of the macro
can
be undone by using the the undo button.
--
Thanks,
Mike