troubleshooting Question

VBA Enable Shortcut Menu Bar?

Avatar of thotovec
thotovec asked on
Microsoft Access
19 Comments2 Solutions3838 ViewsLast Modified:
Hello Experts!

While testing my application, I found a number of users were inadvertently using the various command and menu bars.  To alleviate this, EE gave me a great routine I run at startup which disables all of bars -

    Dim i As Integer
    For i = 1 To CommandBars.Count
    Application.CommandBars(i).Enabled = False
    Next i

After this runs, I also have code for a custom Menu Bar I created which gives users everything they need.
    CommandBars("Custom Menu Bar").Enabled = True
    CommandBars("Custom Menu Bar").Visible = True

This works great for users - but I very much need the shortcut menu bar (right click of the mouse)!  What is this shortcut bar called and how can I add this to my VBA?
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Database Architect / Application Developer
Join our community to see this answer!
Unlock 2 Answers and 19 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 19 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros