Bypass worksheet_change event

[Dr.Schwartz]

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

[Norman Jones]

Hi Dr.Schwartz,

> Activate worksheet_change bypass code
Application.EnableEvents = False

> Reinstate worksheet_change event
Application.EnableEvents = True


---
Regards,
Norman



"Dr.Schwartz" <DrSchwartz@discussions.microsoft.com> wrote in message
news:A748A59F-8287-43FA-9EC2-37BC59F805A2@microsoft.com...
> 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

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

"Dr.Schwartz" <DrSchwartz@discussions.microsoft.com> wrote in message
news:A748A59F-8287-43FA-9EC2-37BC59F805A2@microsoft.com...
> 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

[Dr.Schwartz]

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" <DrSchwartz@discussions.microsoft.com> wrote in message
> news:A748A59F-8287-43FA-9EC2-37BC59F805A2@microsoft.com...
> > 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
>
>
>