I have a spreadsheet (attached) with some VBA code running and if a mistake is made in the workbook, it will NOT allow me to 'UNDO' the mistake.
I am hoping that someone can help me by telling me why this is happening and hopefully correct it...
Thanks and best regards,
leopardhawk
Any macro that changes the workbook flushes the UNDO buffer. It's a good reason not to use macros unless you really need them. Code can be written to support UNDO, but it's messy.
Good afternoon leopardhawk
Unfortunately running a macro clears your undo stack, so you will lose multiple undo levels - there's no way around this. Many have tried and failed to pinpoint the memory address and all kinds of other complicated tricks.
VBA allows you to hijack the undo command to reinstate one undo level to correct any mistakes. this technique is described here.
However, Jan Karel Pieterse provides a routine here that is a generic undo handler - you might find this easier to implement.
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks