Excel starts without any bars...

[Peter Ostermann]

....just showing the plain spreadsheet window.

Hi NG,

how can Excel be reset to the default menuebars/commandbars/
iconbars?

Thanks in advance for a hit.

Regards
Peter Ostermann

 

[Guest]

tools > customise > toolbars > reset

then you probably want to pick

standard
formatting
worksheet menu bar

 

[Peter Ostermann]

tools > customise > toolbars > reset

how is that possible without a menubar?

Peter

 

[Dave Peterson]

You can destroy any existing toolbars and reset them to factory default by:

Close excel
windows start button|search
look for *.xlb
(Look in hidden folders for hidden files, too)

rename them all to *.xlbOLD

Restart excel to test it out.

If it worked, delete those *.xlbOLD files.

If not close excel and rename them back to *.xlb.

This will remove any customized changes from your toolbars.

 

[Chip Pearson]

One way is to go into the VBA Editor, display the Immediate Window (CTRL+G)
and enter following text and press ENTER.

Application.CommandBars("Worksheet Menu Bar").Enabled=True

This *should* restore your menu bar. It is possible that you are in Full
Screen Mode. From the View menu, unselect "Full Screen". If this is case,
you'll get your command bars back. If not, but you do get the menu bar back,
you can use the steps provided by Alllen to display your command bars. Dave
Peterson's method will work, but with the caveat that you will lose any
menu/commmandbar customizations you may have.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)

 

[Peter Ostermann]

Hi fellows,

your hints worked entirely.
Thanks for great support!

Best Regards from Germany
www.pkf-ostermann.de