Deny Worksheet_Change event

[Ark68]

I have a workbook open event that defaults values of certain cells in a worksheet.
As it's doing so, it is triggering the worksheet_change event (triggers code with a specific user cell entry) with each cell that is defaulted.

Is there a way to prevent the worksheet change event from occuring during this process?

 

[RoryA]

Use:

Application.Enableevents = False
' code that changes cells
Application.Enableevents = True

in your Open event.

Oh and ideally, the code to re-enable events would be in an error handler to ensure it always gets called!

 

[DanD]

Application.enableevents = False/True

Will turn events, such as worksheet_change on and off

Must learn to type faster!