Event(s) for opening the workbook AND worksheets
Posted
by
KeyMs92
on Stack Overflow
See other posts from Stack Overflow
or by KeyMs92
Published on 2012-11-12T23:21:25Z
Indexed on
2012/12/01
17:04 UTC
Read the original article
Hit count: 146
I'm looking for an elegant solution to trigger an event for opening the workbook as well as opening different worksheets. I don't need seperate operations for each worksheet: they all trigger the same method.
I know I can use the events Workbook_Activate
/ Workbook_Open
and Workbook_SheetActivate
at the same time but I don't know if this is 'the official way' to do it. Perhaps there's a way to do this with one event.
I was also wondering if it is relevant in this matter where I put the code. I now have all the code inside "ThisWorkbook" and not in a "Module"...
© Stack Overflow or respective owner