Worksheet change events stop working after Debug?

[JumboCactuar]

Hi,
I'm sure some of you have come across this.

If for example I have a worksheet.change event that writes values to cells. Then for any reason I get a debug error in VBA.

The worksheet events stop working until you close/reopen the workbook (well the only way I know of)


Anything I'm missing to prevent this?

 

[dmt32]

Hi,
if in your change event you have this line

Application.EnableEvents = False

and you code bugs - you need to Explicitly re-set it.

You can avoid this by having some error handling

Private Sub Worksheet_Change(ByVal Target As Range)


On Error GoTo myerror
Application.EnableEvents = False


'code


myerror:
Application.EnableEvents = True


'error handling code
End Sub

Dave

 

[JumboCactuar]

Thank you, this will be it.

Didn't even think about the screenupdating