Cannot Undo After Running Macro

[Simon]

Whenever I have run a macro I am unable to Edit>Undo the action that the
macro has carried out.

Does anyone know how to get around this? Thanks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Sharad Naik]

Well, the standard Undo command won't work if the change is through a macro.

If you want to Undo the changes done by macro, you will have to write your
own code for that.

Sharad

 

[Norman Jones]

Hi Simon,

See John Walkenbach at:

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

 

[David]

Suggest making a copy of the worksheet/workbook before you run the macro for
the reasons already stated.