Autoload custom toolbar when opening a workbook

  • Thread starter Thread starter Jim Carter
  • Start date Start date
J

Jim Carter

Can anyone help me? I am trying to get a custom toolbar to load when I load
a specific workbook in Excel. The custom toolbar is designed and working,
but I want to autoload it when I load the specific workbook that it is used
for. What are the VB code lines that will do this?

Thank you for your help.

Jim
 
Set the toolbar to be temporary then recreate it using a Wookbook_Open event
under ThisWorkbook. Works fine for me.

Gavin.Bird

Private Sub Workbook_Open()
Call ToolbarCreate
End Sub
 
Back
Top