ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   preventing macros from clearing the undo list (https://www.excelbanter.com/excel-programming/350328-preventing-macros-clearing-undo-list.html)

John Davies

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

NickHK

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




Dave Peterson

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


All times are GMT +1. The time now is 07:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com