Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to call an application event from a standard module, the
difference here is that it needs to be called each time a new workbook is opened. This has been developed as an addin so that any user can install the application with little or no effort. Initially the code was located in the standard module and any automatic procedures called from ThisWorkbook's Workbook_open event. The code basically builds a custom menu, amongst other things, which checks certain conditions within a workbook and then disables part of the custom menu should these conditions be true. I need this code to be run whenever a workbook is opened, hence application level events - my problem is that workbook_open events are not available on the standard module as far as I know. Am I going about this the right way or are there any alternatives? I hope this is clear. Thanks in advance T. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calling worksheet module from other module. | Excel Programming | |||
Application level events | Excel Programming | |||
Code: Using Excel Application level Events | Excel Programming | |||
Application Level Events Question | Excel Programming | |||
Application level events no longer execute | Excel Programming |