About Us

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" 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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Worksheet_change event.	Mike K	Excel Programming	8	October 24th 04 09:00 PM
2 conditions in Worksheet_Change event	David	Excel Programming	4	July 4th 04 03:47 PM
Worksheet_change event	Dwayne Smith	Excel Programming	2	June 5th 04 03:25 AM
Worksheet_Change Event	cmcfalls[_4_]	Excel Programming	3	April 12th 04 09:47 PM
Worksheet_Change Event	Sam	Excel Programming	2	November 21st 03 06:51 PM

Menu

About Us