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