Mcros conflict, Force Paste Special

Hi all,

I am using the macro below to force user to use paste values, and it works well. However, when I have to run another macro includes copy/paste-special-values, I cannot due to the "UNDO" command.

Is there anything I can add to this macro below to allow other macros to run normally:

Please Login or Register  to view this content.

Hi, Ralem,

if itīs a wanted action you will take via another macro you could disbale events for the run of teh macro and enable them thereafter:

Please Login or Register  to view this content.

Make sure that the events are being turned on at the end of teh macro.

Ciao,
Holger

You don't need the Undo command.
The macro overrides the paste formula with the paste value anyways.

This version should work for normal copy/paste as well as if copy/paste is triggered by another macro.

Please Login or Register  to view this content.