ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   menu and toolbars missing (https://www.excelbanter.com/excel-discussion-misc-queries/53315-menu-toolbars-missing.html)

marzeats

menu and toolbars missing
 
Excel menu and all toolbars are missing from the display. ALT+f does
nothing. Only thing displayed is formula bar and name box. Nothing else.
Can't get it back

Don Guillett

menu and toolbars missing
 
try alt v

--
Don Guillett
SalesAid Software

"marzeats" wrote in message
...
Excel menu and all toolbars are missing from the display. ALT+f does
nothing. Only thing displayed is formula bar and name box. Nothing else.
Can't get it back




marzeats

menu and toolbars missing
 
Nothing. There is no File/Edit/View/Insert/... menu and there are no toolbars.

"Don Guillett" wrote:

try alt v

--
Don Guillett
SalesAid Software

"marzeats" wrote in message
...
Excel menu and all toolbars are missing from the display. ALT+f does
nothing. Only thing displayed is formula bar and name box. Nothing else.
Can't get it back





Dave Peterson

menu and toolbars missing
 
One way is to reset all the toolbars to factory defaults. This will mean that
you'll lose any customized changes to any of your toolbars.

Close excel
windows start button|search
look for *.xlb
rename all of them to *.xlbOLD

Restart excel and see if that fixed it.

If it did, you can delete those *.xlbOLD files.

If it didn't help, just close excel and rename them back to *.xlb.

======
You could also be a little more selective.

Open excel
hit alt-f11 (to get to the VBE where macros live)
hit ctrl-g (to see the immediate window)
type this and hit enter:
application.commandbars("worksheet menu bar").enabled = true

Then back to excel and try to use:
tools|customize to reset/show any toolbar you need.

marzeats wrote:

Excel menu and all toolbars are missing from the display. ALT+f does
nothing. Only thing displayed is formula bar and name box. Nothing else.
Can't get it back


--

Dave Peterson


All times are GMT +1. The time now is 10:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com