Is it at all possible to turn off Worksheet Menu Bar ?

  • Thread starter Thread starter Marvin Hlavac
  • Start date Start date
Marvin,

This VBA code does it

Application.Commandbars("Worksheet Menu Bar").Enabled = False


--

HTH

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

Application.Commandbars("Worksheet Menu Bar").Enabled = False


Hi Bob,

Thanks a million, I thought it wasn't possible. I'm glad I asked. It's cool,
works great. It looks neat with out any toolbars, status bars, menu bars...
just the worksheet visible.

:-) but Bob, *now* I have a problem!!! Since all I really have is the
Minimize, Maximize and Close buttons how can I bring back my Menu Bar when I
need it :-) :-) :-)
 
Application.Commandbars("Worksheet Menu Bar").Enabled = True


Hi Peo,

I know, but the problem now is that when I open Excel all my toolbars
including Menu Bar are gone :-)
All that I have available is my Minimize, Maximize and Close buttons :-)
Not even shortcuts like Alt F work... ;-)

Any help anyone?
 
Martin,

it should only turn off the menu toolbar and if use a macro (press Alt +
F11), click
on the same module that holds the hide menubar macro, just make another sub
under the first with
something like

Sub UnhideMe()
Application.CommandBars("Worksheet Menu Bar").Enabled = True
End Sub

press alt + Q to close the editor and you can press alt + F8 to toggle
between them
The only shortcuts that won't work
are those that open the menu tool bar pull down windows and of course to get
to
the VB editor you can press alt + F11. Shortcuts like Ctrl + F and Ctrl + H
and all
other direct shortcuts will still work
 
alt + F11


Thanks Peo,

That's all I needed ;-) My life's saved ;-)

I love my worksheets with out any tool bars and even without menu bar. The
fewer things I see on my monitor the better.
 
Back
Top