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)