Chips site should get you going on this... The one thing you will want to do
is to put this code into an addin so that it is active as soon as Excel is
loaded. Don't feel bad if this is not going too well this is a tough thing to
get working right... Did you download Chips workbook? Is that working OK for
you? Can you post your code so that we can point you in the right direction
and get you back on track...
--
HTH...

Jim Thomlinson


"Tony Logan" wrote:

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.