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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AutoLoad Custom Tool Bar 3
Toolbar Specific to a Workbook file 5
Custom Toolbar does not display all buttons 2
autoload VBA 4
Custom toolbar add-ins in excel 2010 from Excel 2003 under Windows XP Pro. 1
template toolbars 1
Custom Toolbars and Relative Macros 1
Assign a Custom Toolbar to only one WorkBook 3

Back
Top