Forum Discussion
Ctrl + Z stopped working after using a VBA macro to highlight the row/column after clicking on it
I'm using the second following VBA formula to highlight the row/column after clicking on it that I found here (: https://docs.microsoft.com/pt-br/office/vba/excel/concepts/cells-and-ranges/highlight-...
magic_trance As soon as you run VBA code that changes anything in the worksheet, the undo stack (Ctrl-Z) is cleared. Google for that and you'll find many references describing this fact. Some also describe tricks and workarounds that will enable you to roll back previous actions, but as I understand, that involves more VBA coding.
That's unfortunate, but I'll look into these tricks you mentioned. Thanks for taking your time helping me.
Any idea in how to fix the macro though?
Any idea in how to fix the macro though?
magic_trance Not using VBA much myself so can't help you fixing it, sorry.