If you want your macro to have an undo, you have to take care of it yourself.

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



Kiran wrote:

I have a Sort button on my worksheet which sorts a range od data
alphabetically. On clicking the sort it sorts the data, But if I try to undo
that change it does not work, Ctrl+Z is disabled.
Can anyone let me know (VBA code if needed) how I can take care of this?

Thnx

--

Dave Peterson