Hello
Why the Ctrl+Z and Ctrl+Y stop working everytime using the macro button in my worksheet.
Is there anyway to fix this issue?
Thanks
Hello
Why the Ctrl+Z and Ctrl+Y stop working everytime using the macro button in my worksheet.
Is there anyway to fix this issue?
Thanks
When you run a macro, the Undo Stack is cleared. Consequently, there is nothing to Undo and Ctrl-Z "appears" to do nothing . . . because there is nothing for it to undo.
This is by design. A macro could carry out hundreds, if not thousands of actions making complex changes to cells, ranges, sheets, workbooks, whatever. It would be impossible to undo all but the simplest of macros.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi
Ok. So is there any other way to maybe "reset" the macro so that the Undo be able to work?
Short story: no. Long story: no, see explanation in post #2.
: o) Ok. Thank you TMS
You're welcome.
Sorry, I couldn't give you the answer you wanted to hear.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks