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