I have created an Excel project for my office, and I want to use a navigation
drop-down toolbar, which will allow us to quickly access other sheets in the
workbook.

I have found a great navigation toolbar (created with VB); however, the only
problem is that the navigation toolbar opens for EVERY worksheet. It always
opens up whenever I click "enable macros."

I only want the navigation toolbar to come on for this one workbook. I'm a
newbie with Excel, so I have no idea how to edit the code to make it open for
only one worksheet.

Thanks for your help!

Hide it on the Deactivate event for this workbook, unhide on the activate.

Application.Commandbars("name"£).Visible = False 'True

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Neale Yonde" <Neale wrote in message
...
I have created an Excel project for my office, and I want to use a
navigation
drop-down toolbar, which will allow us to quickly access other sheets in
the
workbook.

I have found a great navigation toolbar (created with VB); however, the
only
problem is that the navigation toolbar opens for EVERY worksheet. It
always
opens up whenever I click "enable macros."

I only want the navigation toolbar to come on for this one workbook. I'm a
newbie with Excel, so I have no idea how to edit the code to make it open
for
only one worksheet.

Thanks for your help!

In your startup template, but workbook code like this:

Private Sub Workbook_Open()

If ActiveWorkbook.Name = "Book2.xls" Then
Application.CommandBars("todo").Visible = True
Else
Application.CommandBars("todo").Visible = False
End If
End Sub


--
Gary''s Student - gsnu200735


"Neale Yonde" wrote:

I have created an Excel project for my office, and I want to use a navigation
drop-down toolbar, which will allow us to quickly access other sheets in the
workbook.

I have found a great navigation toolbar (created with VB); however, the only
problem is that the navigation toolbar opens for EVERY worksheet. It always
opens up whenever I click "enable macros."

I only want the navigation toolbar to come on for this one workbook. I'm a
newbie with Excel, so I have no idea how to edit the code to make it open for
only one worksheet.

Thanks for your help!