JB,

Try running the macro below to change the link from the .xls to the .xla
file. You can also change the path by modifying the code, but as written
this assumes both files are in the same folder.

HTH,
Bernie
MS Excel MVP

Sub RepairUserDefinedButtons3()
Dim CmdBar As CommandBar
Dim i As Integer
On Error GoTo ErrorReading:

For Each CmdBar In CommandBars
For i = 1 To CmdBar.Controls.Count
If CmdBar.Controls(i).BuiltIn = False Then
If InStr(1, CmdBar.Controls(i).OnAction, _
"my-macros.xls") Then
CmdBar.Controls(i).OnAction = _
Replace(CmdBar.Controls(i).OnAction, _
"my-macros.xls", "my-macros.xla")
End If
End If
ErrorReading:
Next i
Next CmdBar
End Sub



"JB" wrote in message
...
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

-----Original Message-----
Yes.
1 - View/Toolbars/Customize
2 - Click New
3 - Enter a name for the toolbar, Click OK
4 - Click the Commands Tab
5 - Select the tool bar buttons you want to put on the
command bar
6 - repeat 5 until it's what you want
7 - Done.

"JB" wrote in
message
...
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.

-----Original Message-----
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/ba...tml/msdn_addin
s97.htm

http://msdn.microsoft.com/library/of...odeopg/deovrcr
eatingexceladdin.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

--
Regards,
Tom Ogilvy

"JB" wrote in
message
...
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?




.