View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Madiya Madiya is offline
external usenet poster
 
Posts: 239
Default Right click menu (context menu) for Rows & col not working

On Dec 26, 4:33*am, "Ron de Bruin" wrote:
Hi Madiya

*Maybe you have a corrupt or bloated xlb file

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 to your system
Excel will create a new file 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 Bruinhttp://www.rondebruin.nl/tips.htm

"Madiya" wrote in ...

On Dec 25, 6:50 pm, "Ron de Bruin" wrote:





Try to reset it


Application.CommandBars("Row").Reset
Application.CommandBars("Column").Reset


--


Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm


"Madiya" wrote in ...
Hi,
I am using excel 2007.
From last few days, my right click context menu for rows and columns
is not working at all.
Although "cell" right click works perfectly.


Pl help.


Regards,
Madiya- Hide quoted text -


- Show quoted text -


Thanks for help Ron.
Tried to reset but no help.
Also right click menu for cell is working but if right clicked inside
tabl, not working

Any further idea pl?

Regards,
Madiya- Hide quoted text -

- Show quoted text -


Ron,
Thanks for your help.
Renaming those files worked.

Thank you again.
Regards,
Madiya