Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
preventing macros from clearing the undo list
The undo facility does not work and I presume that some macros that I am
using on the sheet are clearing the undo list (even though I have not specifically set up any macros to do this). Is there a way to prevent these macros from doing this as it is very irritating Thanks in advance for any help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
preventing macros from clearing the undo list
John,
Actions performed by macros cannot be undone. Hence Undo is greyed immediately after a macro is run. There are solutions - Google NickHK "John Davies" wrote in message ... The undo facility does not work and I presume that some macros that I am using on the sheet are clearing the undo list (even though I have not specifically set up any macros to do this). Is there a way to prevent these macros from doing this as it is very irritating Thanks in advance for any help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
preventing macros from clearing the undo list
You have to take care of it yourself.
John Walkenbach shares this: http://www.j-walk.com/ss/excel/tips/tip23.htm John Davies wrote: The undo facility does not work and I presume that some macros that I am using on the sheet are clearing the undo list (even though I have not specifically set up any macros to do this). Is there a way to prevent these macros from doing this as it is very irritating Thanks in advance for any help -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preventing users from changing macros | Excel Discussion (Misc queries) | |||
Undo macros | Excel Programming | |||
How to avoid clearing undo stack after macro? | Excel Programming | |||
preventing disabling of macros | Excel Programming | |||
Parametrized Macros preventing other macros | Excel Programming |