Thanks for the suggested approaches. I will try them out.

I can't believe it's that difficult in Excel to attach code to individual
(but not all) workbooks! What I want to do is perfectly doable in Word,
which usually isn't as "friendly" as Excel. Uff-dah!

I have code that I want to be available for many workbooks, but don't want
to just insert it in my Personal.xls. I thought an .xla file is
complementary to a .dot file in Word, is that not the case?

st.

"Tom Ogilvy" wrote in message
...
If you use code to create the toolbar each time the addin is loaded and
remove it when it is unloaded and put this code in your Addin, then I
believe you should be able to manage your toolbar without problems.

. http://www.jkp-ads.com/articles/DistributeMacro03.htm

Might be useful.

It might be better to rethink your approach than try to kludge together a
solution. But, I have to admit it is not clear why you want it attached
to
2 different "workbooks/addins"

--
Regards,
Tom Ogilvy

"zSplash" wrote in message
...
I have a non-private macro ("ShowIt") in my installed addin ("FLC.xla")
that
I want to reference in "myToolbar". I have attached myToolbar to the
addin,
as well as to the specfic workbook ("myWorkbook.xls")

When I assign the macro ("ShowIt") to myToolbar, w/o reference to the
addin,
it automatically changes to reference "myWorkbook!ShowIt" (instead of
just
("ShowIt"). The "ShowIt" macro is not in myWorkbook, but in myAddin! I
have tried assigning the macro to myToolbar by referencing
"myAddin!ShowIt",
but that isn't recognized.

So: How do I reference an addin macro in a toolbar for a workbook to
which
the addin is installed? Am I goofing up by attaching the toolbar to the
addin, or what's the deal?

TIA