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

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

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

On Dec 25, 12:01*pm, Madiya wrote:
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

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

Try to reset it

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Madiya" wrote in message ...
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

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

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

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

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


"Madiya" wrote in message ...
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

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