Okay I will try working with all that some more, and yes it is more the
just placing an icon, I have tried earlier placed that code into my
addin, but the moment I do that its doesn't function at all. It seems
to need to have some code in the ThisWorkBook module, which appears to
me to be unique for every workbook.

Thanks for you help.
Tom Ogilvy wrote:
You use one file to instantiate application level events.

this would be your addin.

The appevent.xls file is a demonstration download. You would place similar
code in your addin. When you addin is loaded, then applicationl level events
are instantiated.

However, you seem to want to ignore the fact that for your stated purpose,
of putting an ["icon" on the menu], you don't need application level events.

Jake was responding to what you said which sounded like application level
events. If you want something other than the "icon", then perhaps they are
appropriate. If so, I have provided the information you need to continue.

--
Regards,
Tom Ogilvy

" wrote:

Some more follow up on this, as I still don't seem to be getting my
question answered. (I am sure its my fault for not explaining
properly).

For example I got one response from Jake Marx suggestion to look at
Chip Pearson's tutorial.

This I had already done, and have even used the APPEVENT.xls file. But
from what I can tell, the triggers on the APPEVENT.xls file, will do
exactly what I want, except for one small problem... They only work,
when APPEVENT is open. I want this to fire whenever I open any file,
without having to pre modify each file, and without having to open
APPEVENT. How do I get this functionality at a application level not a
file level.