Menus, Toolbars and Keyboard shorts missing or diabled

D

Dudley Wright

Hi all:

I have lost my menu bar, all toolbars (it is not set to full screen)
and keyboard shortcuts (Alt+T, O for example) dont work.
Help, please.
Dudley
 
D

Dave Peterson

Is it ok to trash any customizations you've made to the toolbar?

If yes:
close excel
windows start button|Find/seach
to look for *.xlb
Rename it/them to *.xlbOLD (just in case)
restart excel.

If it worked, delete those *.xlbOLD files and rebuild your toolbars from
scratch.
 
D

Dudley Wright

Thanks for the feedback.
There are no customizations, and a search for *.xlb yields no results.
Any other suggestions would be appreciated>
 
D

Dave Peterson

make sure you search hidden folders (and for hidden files) in your windows
search.

An alternative is to use the old DOS Command from a command prompt.

(Windows start button|run
for winNT/win2k (winXP??): cmd
for win9*, type: command

Then

dir c:\*.xlb /s /ah

You may have to change the drive letter (depending on where you installed office
and the versions of excel/windows you're using).

The /s means to search subfolders, too. The /ah means to search for files with
(a)ttributes that are (h)idden.

======
One more thing to try first.
Tools|Customize|toolbars tab|
Verify that each of the commandbars you want is checked.
 
D

Dave Peterson

And just in case, this worked for me to search for both hidden and non-hidden
files:

dir c:\*.xlb /s /a
 
Top