View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin
 
Posts: n/a
Default Options (under the tools menu) won't open when clicked in Exce

When you start Excel in Safe mode do you have the same problem then

On the Windows Taskbar
StartRun

and type this

Excel.exe /Safe

Or like this
hold the Ctrl key down when you open Excel.
It will ask you if you want to open in Safe mode

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


"Dana" wrote in message ...
This is what I tried first...ugh! Any other ideas?

"Ron de Bruin" wrote:

Hi

Try to reset your menubar first
ViewToolbars .. customize
Select the Worksheet Menu Bar and click on reset

If this not work try this

Maybe you have a corrupt or bloated xlb file *normal* size is < 30 kb.
The .xlb file has all Toolbar customization in it.

1. Close Excel
2. Do a search for .xlb in Windows (Use: search hidden files and folders)
3. Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb)
4. 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


"Dana" wrote in message ...
Help! I can't get to the options in Excel!!!