E Ed Dec 19, 2003 #1 Is there anyway that when i paste something into a document that it could automatically trigger a macro?
Is there anyway that when i paste something into a document that it could automatically trigger a macro?
D Don Guillett Dec 19, 2003 #2 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
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