hi,
Excel has a lot of built in niceities, the undo is one of them. but they
only work when doing things manually. macro code bypasses all the built in
niceities.
You can not undo anything done with macro code. If you want to undo your
sort, then you will have to write code that will resort your data. maybe
another button.

Good luck
FSt1

"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