Attaching toolbars to spreadsheet, but macros do not follow?

[JB]

I have created some macros which everyone in my department
uses.

I am trying to find the best way for everyone to have
access to these macros AND THE TOOLBAR which has buttons
linked to the macros.

I see one of two ways of doing this.

1) I can place my "office macros.xls" file in everyone's
XLSTART folder, but then I have to create the toolbar and
buttons for every user on every computer (we do a lot of
PC swapping).

2)We have an Excel template which we use at the beginning
of each project... I can embed the macros into the
template and attach the toolbar to the template.

Here is my problem.

The first way is very time consuming, and anytime I create
a new macro or have a change it will be a big headache to
make the change for everyone.

The second way does not work... I can embed the macros and
attach the toolbars, but when I set up the macro buttons
in the toolbar and then Copy the template to another
PC/folder, the macros don't follow... they point back to
the original template which has the macros... not to the
current file with the macros embedded.

Any ideas?

 

[Tom Ogilvy]

One way is to create an addin and put it on a common drive. Then have each
user reference the addin through tools=>Addins so it is opened each time
excel it opened. this allows you to update the file if necessary and
everyone will get the newest version. Create the commandbars with code in
the addin (and delete the existing verion) each time it is opened. Doing
anything on each computer is a non-starter in my opinion.

http://msdn.microsoft.com/library/backgrnd/html/msdn_addins97.htm
http://msdn.microsoft.com/library/officedev/odeopg/deovrcreatingexceladdin.htm
http://www.microsoft.com/exceldev/tips/addins.htm
These are about distributing applications



Here is an article about creating commandbars with code:
http://msdn.microsoft.com/library/techart/ofcmdbar.htm

http://support.microsoft.com/default.aspx?scid=kb;en-us;830502&Product=xlw
How to customize menus and menu bars in Excel

 

[Guest]

Is there a way to create a Command Bar without code???

I AM NOT A PROGRAMMER... I know excel and can make my way
arround VB for applications... though I could probobly do
it, I do not have the time it would take for me to try and
figure this out in code.

 

[Tom Ogilvy]

Here is an article about attaching toolbars:

http://www.microsoft.com/exceldev/articles/toolbatt.htm


http://support.microsoft.com/default.aspx?scid=kb;en-us;213754&Product=xlw2K
XL2000: How to Customize a Custom Toolbar Button

http://support.microsoft.com/default.aspx?scid=kb;en-us;200522&Product=xlw2K
OFF2000: How to Add a Command to a New Toolbar