View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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