Hiding Toolbars Question

  • Thread starter Thread starter Full Monty
  • Start date Start date
F

Full Monty

Excel 97 - I read a post a couple days ago explaining how to hide al
the toolbars when opening a workbook, then unhide them when tha
workbook is closed.

The only thing it left open was the Worksheet Menu Bar. I thought thi
was pretty cool but wondered about a couple of things.

Can you do the same thing except leave open a Custom toolbar yo
created and close the Worksheet Menu Bar? And if so is the code prett
much the same? Or is it another ball of wax?

Since I am learning VBA as I go along, I thought I would get som
opinions on this!

Thanks
 
Monty,

Code is much the same, except with the Worksheet Menu Bar, you don't set the
Visible property to False, you set the Enabled property (to False).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Monty,

Here is a post on the same day as the one you saw which incorporates
Worksheet Menu Bar

http://tinyurl.com/2x4ew

You still need to handle your custom toolbar.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Bob Phillips said:
Monty,

Code is much the same, except with the Worksheet Menu Bar, you don't set the
Visible property to False, you set the Enabled property (to False).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
Click to expand...
 
CommandBars("WorksheetMenuBar").Enabled = False

will hide the bar. The converse will redisplay it.
 
Back
Top