Tony,

This code does not go into a class module, you put it in ThisWorkbook code
module. It uses a slightly different implementation of the technique than
Chip.

And yes, it is fine in the add-in.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Tony Logan" wrote in message
...
One additional question: Is this code I can add to the add-in (the .xla
file)? Or am I going to need to add it to an Excel file?

If I"m understanding Chip Pearson's sample file correctly, if I want to
trigger an action that occurs every time a workbook is opened, I'll need
to
have some .xls file containing my code open, too.

And so my solution seems two-fold:
1. Write code that triggers an action whenever a workbook is opened.
2. Write code that opens the doc containing the code for #1 any time Excel
starts.

Just want to make sure I'm heading down the right path.

Thanks.