preserving "undo" function when using VBA for shortcuts...

[sadams1]

I've found out through setting up simple VBA keyboard shortcut macros that using them results in the "undo" not available afterward. For example, a macro that pastes "values only" with a keyboard shortcut is unable to be undone which is not the case when using non VBA shortcuts. Am I smoking too much crack or is it possible to use VBA shortcuts & preserve the ability to undo it?

 

[Fluff]

Whenever a macro makes changes to a workbook, then you loose the undo history.

 

[sadams1]

Thank you for the reply!

 

[Fluff]

You're welcome.

 

[mikerickson]

You might look at Application.OnUndo

Application.OnUndo method (Excel)

Office VBA reference topic

docs.microsoft.com

It allows you to put a routine that un does your routine into the UnDo stack, although it still clears all the previous stack of undo's.