Halting the Worksheet_Change event
 

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 cant just delete the handler

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

Regards

James

Halting the Worksheet_Change event
 

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.

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

Regards,

James.

.

Halting the Worksheet_Change event
 

Thanks Frank

Jim...