So if you reopen the file then the changes are gone? then it definately
HASN'T saved has it??

It hasn't saved it. That's for sure. May be it disables the undo button
or just doesn't keep log of changes. But what I observed is that it
also doesn't allow to undo the changes I did before running the macro.
I.e if I have done some changes, they are available to undo before
running macro. As soon as I run it, they are lost. The undo button is
disabled and even Ctrl + Z for that matter doesn't do anything.

If I reopen, it will open in the last saved state.

Regards,
Manoj

Most macro commands will cause the undo history to be lost. Undo doesn't
support changes made by macros. Thus, when a macro changes the spreadsheet
environment, the context of the undo has been lost and therefore Undo gets
disabled is my surmise.

--
Regards,
Tom Ogilvy

wrote in message
ups.com...
It hasn't saved it. That's for sure. May be it disables the undo button
or just doesn't keep log of changes. But what I observed is that it
also doesn't allow to undo the changes I did before running the macro.
I.e if I have done some changes, they are available to undo before
running macro. As soon as I run it, they are lost. The undo button is
disabled and even Ctrl + Z for that matter doesn't do anything.

If I reopen, it will open in the last saved state.

Regards,
Manoj

So can't we save this undo history (or whatever) and restore back while
ending macro?

Yes, but you have to do the dirty work yourself.

The link that Rowan gave you in the first reply showed one way of doing this.

wrote:

So can't we save this undo history (or whatever) and restore back while
ending macro?

--

Dave Peterson