menubar visibility problem

[rikrak]

In a network a number of people access an Excel-sheet which is located on a server.
At the time the sheet was created a menubar was created too.
Everone can use the menubar that contains 2 buttons.

Today I added 3 additionals buttons, but I'm the only one who sees 5 buttons.
What's the trick to make all 5 buttons visible for all users.

Henk

 

[Swamp Thing]

The new menu bar is probably saved in a default workbook (eg personal.xls). To attach it to the current book:-

Tools > Customize > [Select Toolbars tab]

Select the new toolbar, then click the "Attach.." button. You will then get a dialog box where you can move the toolbar from the custom toolbars list to the current workbook using the "copy" button.
This message was edited by Swamp Thing on 2002-08-22 03:16

 

[rikrak]

I already did the "copy" action when i created the sheet, otherwise the other users would not be able to use "my" menubar. The problem now is that they don't see the changes i made.

 

[mweaver]

rikrak,

I have had similar problems with toolbar modification in Excel 97. Upon making additional changes to a previously created custom toolbar, I have found that I must unattach or delete the existing bar from the workbook before I can attach the NEW bar with the same name!

Treat this modified bar like a brand new bar and (after deleting the existing custom bar) you can attach your bew bar to the workbook.

hope this helps

mweaver

 

[rikrak]

mweaver,
Thanks for the tip. The problem now is that users don't know when there's a new menubar.
So I added following code:
Private Sub Workbook_BeforeClose(Cancel as Boolean)
Application.CommandBars("Week").Delete
End Sub

Every time I change the menubar (don't forget the "copy" action) it will be visible for all users. When a user opens the sheet for the first time the old menu is visible, but after that ......)

Henk

 

[KniteMare]

Menus can also be created "on the fly" and set to become part of the tool bar at the top of the screen. I set mine up to be created when the file opens and to removethemselcves when the user leave the file by any means. If you want to explore this somewhat more complex but edit friendly procedure. PM me and I'll send you one of my test files.

Yours in EXCELent Frustration

KniteMare

 

[rikrak]

KniteMare,

Thanks for sending the information. I make menubars on the fly now.

Henk