....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

tools customise toolbars reset

then you probably want to pick

standard
formatting
worksheet menu bar
--
Allllen


"Peter Ostermann" wrote:

....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

"Allllen"


tools customise toolbars reset


how is that possible without a menubar?

Peter



then you probably want to pick

standard
formatting
worksheet menu bar
--
Allllen


"Peter Ostermann" wrote:

....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

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.

Peter Ostermann wrote:

...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

--

Dave Peterson

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" wrote in message
...
...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

Hi fellows,

your hints worked entirely.
Thanks for great support!

Best Regards from Germany
www.pkf-ostermann.de


"Peter Ostermann" wrote

...just showing the plain spreadsheet window.

Hi NG,

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

Thanks in advance for any hint.

Regards
Peter Ostermann