View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tony Logan Tony Logan is offline
external usenet poster
 
Posts: 11
Default run macro whenever any workbook opens

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.