ok... but not a solution to my original post...

[JB]

ok... commandbar, toolbar are one and the same... got it.

That still leaves me without a solution to my original
post... (SEE BELOW) ...

I copied all of my macros into a blank spreadsheet... via
VB editor... moved modules containing macros from old
spreadsheet into a new.

..... while still in the new book, I created the toolbar,
inserted the macro buttons with links to the macros
recently moved to this new book.

I saved the file "my-macros.xls" and then saved as an add-
in "my-macros.xla", opened the spreadsheet I am working on
and loaded the add-in.

Everything works until I remove/delete "my-macros.xls".
then the macros are looking to the old .xls file, not to
the .xla add-in which I loaded.

THE ADD-IN FILE IS NOT SELF CONTAINED!!

I NEED TO BE ABLE TO DISTRIBUTE THE FILE TO ALL IN MY
DEPARTMENT WITHOUT HAVING TO SET UP NEW
TOOLBARS/BUTTONS/MACROS ON EVERY MACHINE FOR EVERY USER.

Thoughts??

Thanks for your help!
JB

 

[Bob Kilmer]

Did you attach the toolbar to the workbook that you saved as an addin? Tools