turn off worksheet_change during run of procedure

[Laavista]

Thanks to the help in this forum, I was able to successfully create a "worksheet_change" where a message is displayed if the user changes a value in a critical cell.

Now I need to find out if there's a way to 'turn off' the worksheet_change when running another procedure. I have a procedure that checks the critical cell value for errors, and it brings up the message for each row.

Thanks for your help!!

 

[jbeaucaire]

Sub Test()

Application.EnableEvents = False   ' turn off all other macros for now

...code
...code
...code

Application.EnableEvents = True   ' turn other macros back on
End Sub

Be careful here. When you turn off macros like this, your macro needs good error handling built in so that when an error occurs, macros get turned back on.

 

[VoG]

Try

Application.EnableEvents = False
'
'your code
'
Application.EnableEvents = True

 

[Laavista]

Thank you so much! This forum is exceptional!