| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application Event Question
I want to use the Workbook.Activate application event to detect when a
worksheet has been activated, and then depending on which one, do something... I have seen reference on this site to catching this event in the "ThisWorkBook code module", but I don't know where that is. I tried creating a module with that name, and told me that it was already in use. I'm sure that I am missing something that should be obvious, but where is or how do I create the "ThisWorkBook" code module. Thanks, Steve |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Application Event Question
Never mind.....I found it. I knew it was something obvious.....I have ~100
sheets in my workbook, and ThisWorkbook is the last in the LONG list, so I never saw it in there.... "Steve Haack" wrote: I want to use the Workbook.Activate application event to detect when a worksheet has been activated, and then depending on which one, do something... I have seen reference on this site to catching this event in the "ThisWorkBook code module", but I don't know where that is. I tried creating a module with that name, and told me that it was already in use. I'm sure that I am missing something that should be obvious, but where is or how do I create the "ThisWorkBook" code module. Thanks, Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Application level event help | Excel Discussion (Misc queries) | |||
| Application Maximise event | Excel Programming | |||
| how to add a sub at the application level open event? | Excel Programming | |||
| Application Event Procedure <Falling Over | Excel Programming | |||
| Trigger an Excel VBA event from another application | Excel Programming | |||
Linear Mode
