We help IT Professionals succeed at work.

Clicked X on custom toolbar in Access 2007 - cannot get it back

I have a database with a toolbar menu that was created in Access 2003. A user clicked and dragged the menu off of the top part of the window then clicked X to close it. I cannot figure out how to get the menu back on their machine.

The menu bar is a 2003 style, and incorperated within 2007.

I attached some images to show how it was removed from the screen.

Thanks for the help ahead of time!

Dan
CUSTOMMENUIMAGES.png
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2013
Commented:
In vba


Commandbars("youcommandbar").visible = true
Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007
Commented:
Put these two lines of code in a VBA Function, then call that function from the VBA Immediate window.

   CommandBars("YourMenuBarName").Enabled = True
   CommandBars("YourMenuBarName").Visible = True

mx

Author

Commented:
I tried it but i get the following error;

Runtime Error 5
invalid procedure call or argument

Author

Commented:
Wait that worked!
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2013

Commented:
What the name of your custom commandbar menu?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
Twice within 2 hours - almost same situation came up, with same solution.

mx

Explore More ContentExplore courses, solutions, and other research materials related to this topic.