Application.EnableEvents = False
Paste clipboard content
Application.EnableEvents = True

--
Regards,
Tom Ogilvy

"Dr.Schwartz" wrote in message
...
Is there some way to temporarely bypass the worksheet_change event. So
something like:

Sub Insert_During_Bypass

Activate worksheet_change bypass code
Paste clipboard content
Reinstate worksheet_change event

End Sub

Thank you
The Doctor