Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Screwed Up my Right Click Context Menu, Please Help | Excel Programming | |||
Undo button in the context menu (right click menu) | Excel Programming | |||
Custom Context menu (Right click menu) not working in sheet changeevent. | Excel Programming | |||
Right click Drag and Drop context menu | Excel Programming | |||
Right-Click (Context Menu) | Excel Programming |