Enable Undo after Macro has Run

I'm using the following code (kindly provided by quekbc) but I've just realised that running the code results in the blue 'Undo' arrow being greyed out preventing people Undoing their last action. Is there a way amend the code to keep 'Undo' enabled.

Please Login or Register  to view this content.

Many thanks

Good afternoon Hangman

As you've just found out, a side effect of VBA is that every time your routine runs, your undo stack will be cleared. The only simple way to deal with this is not have the event running from a selection change, as the routine is then constantly running.

However, as this is a well known issue, greater minds than mine have wrestled with a solution. A very clever and elegant "one size fits all type" solution is available here.

The only problem is, it's not really for beginners, involving class routines and the like, but it is well explained.

HTH

DominicB

Um, Thanks Dominicb,

This seems like such a basic requirement, but appreciate it is a well known issue. So that means no quick fix then right? I'll take a look at your link, but I really am a VBA novice, so unsure how much sense it will make...

Thanks