Hi,
I have developed a custom toolbar that acts as a user interface to run
commonly used macros.

How can I export this toolbar and the corresponding macros to allow someone
else in my department for usage?


Please advise.

"Attach " the toolbar to the workbook (search help for "attach toolbar").
The macros should be in the workbook that has the toolbar attached.

In the ThisWorkbook code module add code to delete the toolbar when
the workbook closes and show it when the workbook opens....
'--
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("Steve's Toolbar Name").Delete
End Sub
'--
Private Sub Workbook_Open()
Application.CommandBars("Steve's Toolbar Name").Visible = True
End Sub
'--
NOTE: that if you make any changes to the toolbar you have to remove
the existing toolbar and attach the revised one!
You can now send a copy of the workbook to others.

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"Steve P"
wrote in message
Hi,
I have developed a custom toolbar that acts as a user interface to run
commonly used macros.

How can I export this toolbar and the corresponding macros to allow someone
else in my department for usage?


Please advise.