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

[Marvin Hlavac]

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

 

[Bob Phillips]

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)

 

[Marvin Hlavac]

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

 

[Peo Sjoblom]

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

 

[Marvin Hlavac]

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?

 

[Peo Sjoblom]

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

 

[Marvin Hlavac]

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.