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.

.