Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop macro from saving changes
So if you reopen the file then the changes are gone? then it definately
HASN'T saved has it?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop macro from saving changes
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop macro from saving changes
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop macro from saving changes
So can't we save this undo history (or whatever) and restore back while
ending macro? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop macro from saving changes
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop someone saving a web downloaded workbook? | Excel Discussion (Misc queries) | |||
My hyperlinks stop working on saving the workbook | Excel Discussion (Misc queries) | |||
How do I stop Excel from saving a file with a different name? | Excel Discussion (Misc queries) | |||
how do I stop warnings when saving .xls as csv? | Excel Discussion (Misc queries) | |||
Stop Saving | Excel Programming |