MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Displaying a custom toolbar

Posted by Lori D on September 17, 2001 7:30 AM

I want to have my custom toolbar display each time the workbook it belongs to is opened, but I don't want to see it every time I open Excel. What am I doing wrong? Any help is greatly appreciated.

Posted by Keith on September 17, 2001 12:13 PM

Hey Lori,

The following macro pasted into the form at the "Open" declaration should open the bar when you go into the file:

Application.CommandBars("Custom 1").Visible = True

Then, pasting the following into the "Before Closing" portion, you'll close it:

Application.CommandBars("Custom 1").Visible = False

Where Custom 1 is the name of your toolbar.

Hope this helps.