Worksheet Menu Bar

S

Spencer Hutton

How can i have the menu bar invisible when a workbook opens. i have tried:
Application.CommandBars("Worksheet Menu Bar").Visible = False
without any luck. is this not possible? TIA.
 
B

Bob Phillips

Try Enabled = False instead.

--

HTH

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

Chip Pearson

Spencer,

Use the Enabled property rather than the Visible property.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top