VB Code causes "undo" to stop functioning

**Rory Murphy** · 04-07-2010, 10:21 AM

I've added the following code to highlight cells when they change

Please Login or Register  to view this content.

All works as I want but the "undo" function in excel is now not working. When I remove the code it works again?
Any ideas

Thanks
Rory

**dominicb** · 04-07-2010, 10:56 AM

Good afternoon Rory Murphy

Please note our rule regarding code tags : I have added them for you on this occasion - please be sure to use them in future to avoid your thread being closed. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

It is unfortunate that using macros usually clears the undo stack - most, but not all instructions will cause this to happen. As your macro fires every time a change is made to your worksheet, the undo is constantly being cleared.

There is no workaround. Choose to live without your macro firing at every change, or choose to live without the undo functionality.

HTH

DominicB

**Marcol** · 04-07-2010, 10:57 AM

You can't undo changes to a workbook made with VBa, removing the code makes no difference, you can only undo manual changes. Try some manual changes after your code runs you will be able to Undo them.