On Paste

[Ed]

Is there anyway that when i paste something into a
document that it could automatically trigger a macro?

 

[Don Guillett]

Try this:

Put =Now() somewhere on your sheet

Right click sheet tab>view code>insert this>Save

Private Sub Worksheet_Calculate()
MsgBox "Hello"
End Sub

try your paste