Using SheetChange

[Rasm]

I am using the event below in ThisWorkBook - However I am filling a sheet via code rather that the Excel GUI - how can I disable that event while I am filling the sheet - when I am done I want to turn it back on.


Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

[Admin]

Hi Rasm,

Turn off Application.EnableEvents

Application.EnableEvents=False
code
Application.EnableEvents=True