disable menu & shortcut menu

[algiersnola]

I know there is a way to disable the menu options under the database options in the top left microsoft button, but I want to disable everthing using vba. I want everthing disabled on startup so the user cannot alter the database in anyway and when I click on a Maintenance button on a form I want all menu's to enable so I can fix or change objects as i see fit.

 

[ajetrumpet]

are you talkinga bout the command bars or are you talking about shortcut menus and toolbars?

 

[algiersnola]

well, I just want to disable all menu and right click shortcuts. I don't want the user to modify any tables, forms, or reports. but I want to be able to enable everything so I can make changes.

 

[ajetrumpet]

On Error Resume Next

Dim i As Integer

For i = 1 To Application.CommandBars.Count

    Application.CommandBars(i).Visible = False

Next i

CommandBars("menu bar").Visible = False