Halting the Worksheet_Change event

[Guest]

Dear Group

I am inserting the contents of a worksheet from a database but every time I change the contents of a cell the Worksheet_Change event is fired. However, I do need to use the Worksheet_Change within the application so I can’t just delete the handler

Is there any way I can stop this event from firing until the sheet has been created

Regards

James

 

[Frank Kabel]

Hi
insert the line
application.enableevents = False
before your insert something into your sheet and enable
the events afterwards with
application.enableevents = True

-----Original Message-----
Dear Group,

I am inserting the contents of a worksheet from a

database but every time I change the contents of a cell
the Worksheet_Change event is fired. However, I do need to
use the Worksheet_Change within the application so I canâ?
Tt just delete the handler.

 

[Guest]

Thanks Frank

Jim...