Running macro clears undo options

[Curtiosity]

I created a macro in my personal.xlsb in Excel 2007 to paste values and assigned it to the keystroke ctrl-q.

When I use this macro, it clears out my options to undo any actions, which is something I really need sometimes.

Is there a different way I could make a macro to paste values with a keystroke combination so that it won't have this effect on the undo feature?

Thanks,

Wendy

 

[JasonC71]

Yes, it can be done..but you have to write code to handle it...the Excel built in undo cannot undo the actions of VBA code.

 

[Weaver]

One method I've used in the past is to make the macro save the file first, so you have a recoverable position, but this might be too slow for some applications.