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

[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

 

[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

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

 

[Ron de Bruin]

Try to reset it

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

 

[Madiya]

Try to reset it

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

--

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







- 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

 

[Ron de Bruin]

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 -

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

 

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

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

Thank you again.
Regards,
Madiya