Disabled (greyed out) menu bars

[Steve]

On my Excel 2002 my Insert, Format & Tools options on my
menu bar are disabled. Have tried all the usual fixes (re-
install, rebooted) but this hasn't solved the problem.

Any ideas ????

 

[Frank Kabel]

Hi
is the workbook/worksheet protected?

 

[Ron de Bruin]

If you try to reset the menubar then do this

Try this

Often this is a corrupt or bloated toolbar file
*normal* size is < 30 kb.
The .xlb file has all Toolbar customization in it.

Close Excel
Do a search for .xlb in windows
Rename the file you find (my file is named Excel10.xlb in 2002)
Start Excel

Deleting the file or renaming will do no harm on your system
Excel will create a new one for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
This file is important (backup it so you can restore it)

 

[Guest]

I'll give it a go now. Thanks for your quick response.

-----Original Message-----
If you try to reset the menubar then do this

Try this

Often this is a corrupt or bloated toolbar file
*normal* size is < 30 kb.
The .xlb file has all Toolbar customization in it.

Close Excel
Do a search for .xlb in windows
Rename the file you find (my file is named Excel10.xlb in 2002)
Start Excel

Deleting the file or renaming will do no harm on your system
Excel will create a new one for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
This file is important (backup it so you can restore it)



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Steve" <[email protected]> wrote in

message news:[email protected]...