Hiding Menu Bars

G

Gerald Stanley

The approach I take is to create my own custom menu, make
it visible and make all the other command bars invisible e.g.

Dim bar As Office.CommandBar

Application.CommandBars("mnuCustom").Visible = True
For Each bar In Application.CommandBars
If bar.Name = "Menu Bar" Or bar.Name = "mnuCustom" Then
ElseIf bar.Visible Then
bar.Visible = False
End If
Next

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
When I open my Form I do not want any menu bars showing.
How is this possible? I can hide some bars on my machine,
but when others open it they still see what I do not want
them to.
 
Top