Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am trying to migrate all code from a .xls file to a .xla file for maintainability purposes. The original code, when it was in the .xls file, was triggered from workbook events like Workbook_Open. In the new .xla file, the Workbook_Open event triggers only when the .xla file opens, not when other .xls files are opened. I need to access the events of every opened workbooks in the excel session *from the .xla file* to make the code run correctly. As I noticed, the .xla itself act like it was a workbook and every events I can catch from there are the .xla's own workbook events. I need to get events from all other opened workbooks as well. How can I achieve this? Thanks in advance. C. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Understand Workbook/Worksheet Events | Excel Discussion (Misc queries) | |||
Workbook-Events donīt work with ChartObjects | Excel Programming | |||
Workbook Events | Excel Programming | |||
Events for workbook close | Excel Programming | |||
Detect more info when workbook does not ack right. | Excel Programming |