macro to run after pasting (ctrl+v)

[aarona]

Hi All,

we have a macro that will run if you hit ctrl+m, i want to modify this macro, i want the macro to automatically run after the users used the paste shortcut key ctrl+v

is this possible?

Thanks.

[sktneer]

One way is you can call your macro within the Worksheet Change Event. Right click on Sheet Tab --> View Code --> And paste the code given below into the opened code window.
Replace the YourMacro with name of your macro which you want to call.

Please Login or Register  to view this content.

[aarona]

Thanks sktneer

[sktneer]

You're welcome!