Undo option not enabled

[vijayakalyan]

hai ,

i have written a macro which will convert the selected cells in
the userdefined format. i have assigned this macro to the existing coma
button. now if i run this macro by clicking the coma button the undo
option is disabled. plz anyone can help me out....

File Attached: http://www.excelforum.com/attachment.php?postid=320738 (kalyan macros.txt)

 

[Peo Sjoblom]

You can't undo a macro with edit>undo

 

[Dave Peterson]

Just to add to Peo's comment.

You have to keep track of the way it was before you started.

John Walkenbach has some notes/example code at:
http://j-walk.com/ss/excel/tips/tip23.htm