Disable Mouse Right Click

[data808]

Yeah everyone right now is pointing me in the direction of creating a custom ribbon. However when I ask about the right click in a custom ribbon if it will give that pesky customize quick access toolbar option, no one really knows or they said it will still give that option.

Can anyone with a custom ribbon test this for me? I just want to know for sure before I commit to learning how to make a custom ribbon. Seems like a lot of work for nothing if it can't prevent the customize quick access toolbar option when you right click in the ribbon area.

[data808]

How do you do that to restore the menus back with a password? That sounds like a great option however I don't even know where to begin to start making customized menus and ribbons. Do you have a link to an example of these things where I can just add it to my database and add and remove things to it?

[trevor40]

I have this for my Tab menu

Private Sub main_menu_tab_Change() ' Or use the click event of an object on your form
With Me(contabs)
Select Case .Pages(.Value).Caption
Case "S&ystem"
If InputBox("Enter Password", "PW Check", vbOKCancel) = 1234 Then

'your code goes here

Else
Screen.PreviousControl.SetFocus
End If
Case Else
End Select
End With
End Sub
' PS the & symbol makes the next letter the shortcut key for changing to that page if the tab control has the focus

It's very basic, you have to adapt it to your situation I only use Access 2003 at the moment, perhaps somebody else with experience in ribbon control using vba can help

[amrut]

This is a very good resource for learning access ribbon http://www.accessribbon.de/en/.
See the attached example.NoRibbon.accdb