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?magic_trance Not using VBA much myself so can't help you fixing it, sorry.
