Bypass worksheet_change event
 

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

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

Bypass worksheet_change event
 

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

Bypass worksheet_change event
 

Thank you Norman - again...

"Norman Jones" wrote:

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