Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Okay, I admit it; I don't get Event Class Modules, which it sounds like I
need to solve my problem. I have a macro that checks for the existence of a particular font in a workbook. If that font is found, a message box instructs the user what to do. If the font isn't found, nothing happens. I want to run that macro any time a user opens a workbook. I looked up "Using Events with the Application Object" in the help files, but I can't make it work. I also had a look at Charles Pearson's site (http://www.cpearson.com/excel/AppEvent.htm), but that looks like the code is getting added to the "This Workbook" module, which doesn't work for my situation (unless I'm reading it wrong, which is possible). Any help would be appreciated. I'm using Excel 2003 for Windows XP, Service Pack 2. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
when opening an Excel Workbook, another blank workbook also opens | Excel Discussion (Misc queries) | |||
when opening an Excel Workbook, another blank workbook also opens | Excel Discussion (Misc queries) | |||
When attempting to run macro Excel opens different workbook | Excel Programming | |||
Personal workbook opens when Excel opens | Excel Discussion (Misc queries) | |||
Run Macro when workbook opens | Excel Programming |