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