Toolbars that won't stay in place

[Guest]

Using Excel 2002. Have several custom toolbars attached to certain files, and each button has a macro associated with it. When you keep a file in the same directory and never rename or save as another name, excel has no problem finding the toolbars or macros. However, when you use a file on different PC's (work and home), every time you pull it up it from the new location, excel can't find the macros associated with the toolbars

To get around this, you can attach the toolbars to the file but use an auto_close macro which deletes the toolbars each time you close the file. Then when you reopen the file, the attached toolbars are there and excel can find the macros. However, this too creates a problem - the toolbars will not stay in place, and every time you open the file, you have to rearrange the toolbars

It is very frustrating to not be able to accomplish what should be a simple task. If anyone has any ideas on this, please respond. Thank you.

 

[Greg Wilson]

Can you not just specify the tool bar positions using the
Workbook_Open event or Auto_Open macro or am I missing
something?

Application.CommandBars("MyToolbar").Position = msoBarTop
or
With Application.CommandBars("MyToolBar")
.Left = 100
.Top = 50
End With

Regards,
Greg

-----Original Message-----
Using Excel 2002. Have several custom toolbars attached

to certain files, and each button has a macro associated
with it. When you keep a file in the same directory and
never rename or save as another name, excel has no problem
finding the toolbars or macros. However, when you use a
file on different PC's (work and home), every time you
pull it up it from the new location, excel can't find the
macros associated with the toolbars.

To get around this, you can attach the toolbars to the

file but use an auto_close macro which deletes the
toolbars each time you close the file. Then when you
reopen the file, the attached toolbars are there and excel
can find the macros. However, this too creates a problem -
the toolbars will not stay in place, and every time you
open the file, you have to rearrange the toolbars.

It is very frustrating to not be able to accomplish what

should be a simple task. If anyone has any ideas on this,
please respond. Thank you.