sheetchange

M

masterphilch

Hi

I created a Workbook_SheetChange-Event and it works really fine!

Further, I've got other macros for automation. Is it possible to prevent
launching this event while other macros are changing the worksheets??
Performance would be a bit better...

tanks for replies
masterphilch
 
D

Dave Peterson

You can turn off events before you do something that would cause another event
to fire.

application.enableevents = false
worksheets("sheet1").range("a1").value = "hi there"
application.enableevents = true
 
M

masterphilch

thanks

Dave said:
You can turn off events before you do something that would cause another event
to fire.

application.enableevents = false
worksheets("sheet1").range("a1").value = "hi there"
application.enableevents = true
Click to expand...
 
Top