Right click pop up menu

M

Monsoonmarble

Has anyone every had a problem with right-clicking in excel in any workbook
and the pop up menu have things greyed out and not available? Like copy and
cut and format cells? I try to reinstall/repair excel only with no success. I
also tried removing Excel then installing it again no success. I am using
Excel 2000 SR-1 in Windows 2000 Pro.
 
R

Ron de Bruin

Hi

Try to rename your .xlb file

maybe you have a corrupt or bloated xlb 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 (mine 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)
 
J

Jason Morin

Try this macro:

Sub RestoreIt()
CommandBars("Cell").Reset
End Sub

To run, press ALT+F11, go to Insert > Module, and paste
in the macro above. You can run it from VBE or while in
XL, Tools > Macro > Macros.

HTH
Jason
Atlanta, GA
 
Top