LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
when opening an Excel Workbook, another blank workbook also opens Gord Dibben Excel Discussion (Misc queries) 0 October 12th 07 09:49 PM
when opening an Excel Workbook, another blank workbook also opens spmu Excel Discussion (Misc queries) 0 October 12th 07 01:46 PM
When attempting to run macro Excel opens different workbook Rasta Excel Programming 0 July 27th 05 08:46 PM
Personal workbook opens when Excel opens SheriTingle Excel Discussion (Misc queries) 2 March 30th 05 12:22 AM
Run Macro when workbook opens Jean-Paul Viel Excel Programming 0 August 28th 03 08:59 PM


All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"