Halting the Worksheet_Change event

J

Jim McLeod

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
 
F

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
Click to expand...
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.
 
Top