Bypass worksheet_change event
Hi Dr.Schwartz,
Activate worksheet_change bypass code
Application.EnableEvents = False
Reinstate worksheet_change event
Application.EnableEvents = True
---
Regards,
Norman
"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
|