how to recover the menu

[Naveed Pathan]

hii friend i did something wrong with my menus

basically i pressed alt + and select the file menue and drag it down so that
was deleted and now i want to get back
though i reinstall ms office etc but useless
so is there anychance to get my file menu including all other menus can get
back
thanxk

 

[Mark Andrews]

Try running this code:
Note: you need to add a reference to Microsoft Office XX Object library
I usually just run it from the immediate window

Public Function ShowAllMenus()

Dim i As Integer
Dim cbarMenu As CommandBar

For i = 1 To CommandBars.Count
CommandBars(i).Enabled = True
Next i

End Function

HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com

 

[Naveed Pathan]

hi
i tried that but it don't work
thankx for your suggestion i appreciate that ;

 

[Rick Brandt]

hi
i tried that but it don't work
thankx for your suggestion i appreciate that ;

All modifications to built-in command bars (toolbars and menus) are stored
in the Windows system registry at this location...

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Settings\CommandBars

The "11.0" part varies with your version of Access.

These are not individually editable as they are binary key values, but if
you delete all of the keys in the CommandBars folder (or just delete the
folder itself), all of your modifications will be removed and the menus and
toolbars will be reset to their default configurations.

 

[Naveed Pathan]

hi

i am using windows Xp
i am trying through "Run" available on the start menue to get to

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Settings\CommandBars

but i can't
could u please tell me how to access that
thankx

 

[Naveed Pathan]

yes i got it now in

regedit

thankx youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu so much

 

[John Spencer]

One of these should work for you

Run RegEdit
or
Run RegEdit32.exe

WARNING: Be Careful, you can mess up your computer if you do the wrong things
in the registry.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County