sheetchange

[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

 

[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

 

[masterphilch]

thanks

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