How can I update a Attached Custom Toolbar in a shared file?
 

I use an Excell spread sheet in Shared Mode with an attached custom toolbar.
I need to update that tool bar but when I open the file I get the old tool
bar. I already am deleting the existing tool bar when I close down and have
tried ua-attaching the old tool bar and re-attaching the new one. I am
attempting to keep the name of the tool bar from changing as my people know
what to look for.

How can I update a Attached Custom Toolbar in a shared file?
 

Once you have your shared workbook open, go to TOOLS-CUSTOMIZE, then click
ATTACH.
You have to click the tool bar in the workbook and delete it, then readd iit
from the custom toolbar side.

Then save the workbook and close it. once its closed then go back into
customize and delete the toolbar.

The next time you open the workbook, it should be the new toolbar.

One thing I do is make an auto open and close macro in a workbook that is
shared so that if I update the toolbar or the code they will always get hte
latest when they open it.
EX.
Sub Auto_Open()
On Error Resume Next
Application.CommandBars("TOOLBAR").Visible = True
End Sub

Sub Auto_Close()
On Error Resume Next
Application.CommandBars("TOOLBAR").Delete
End Sub


"follyman" wrote:

I use an Excell spread sheet in Shared Mode with an attached custom toolbar.
I need to update that tool bar but when I open the file I get the old tool
bar. I already am deleting the existing tool bar when I close down and have
tried ua-attaching the old tool bar and re-attaching the new one. I am
attempting to keep the name of the tool bar from changing as my people know
what to look for.