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
but when others open it they still see what I do not want
them to.
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
How is this possible? I can hide some bars on my machine,-----Original Message-----
When I open my Form I do not want any menu bars showing.
but when others open it they still see what I do not want
them to.