How can I share custom Toolbars and Menus

[Guest]

I'm using Excel 2000 and I've created a macros, custom memu and a custom
toolbar. These work OK but when I send the file to another user the macros
are included but the toolbar and menu isn't.

Can you suggest a way to do this?

Many thanks

 

[Guest]

paste the following in workbook open event

==================================================
Private Sub Workbook_Open()
Application.CommandBars.Add(name:="Custom 1").Visible = True
Application.CommandBars("Custom 1").Controls.Add Type:=msoControlButton,
id _
:=2950, Before:=1
End Sub
==================================================

change appropriate values in the above code.

*** Please do rate ***

 

[Guest]

Hello Maturin, I have a similar probelm in Excel 2003. 'Attaching' the
toolbar to the spreadsheet improved things but has not proved a complete
solution but it might work for you.

Right click the toolbar, customise, attach.

Richard