Right click menu (context menu) for Rows & col not working

  • Thread starter Thread starter Madiya
  • Start date Start date
M

Madiya

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
 
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
Click to expand...

I have even tried this code but no help.
Sub yy()
On Error Resume Next
For Each bar In Application.CommandBars
Debug.Print bar.Name
bar.enable = True
Next
On Error GoTo 0
End Sub

Pl help.

Regards,
Madiya
 
Try to reset it

Application.CommandBars("Row").Reset
Application.CommandBars("Column").Reset
 
Try to reset it

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

--

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







- Show quoted text -
Click to expand...

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
 
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 Bruin
http://www.rondebruin.nl/tips.htm


Try to reset it

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

--

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







- Show quoted text -
Click to expand...

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






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 -
Click to expand...

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

Thank you again.
Regards,
Madiya
 
Back
Top