SOLVED
Home

Mouse right click pop-up menu stopped working in Excel 2013

%3CLINGO-SUB%20id%3D%22lingo-sub-204703%22%20slang%3D%22en-US%22%3EMouse%20right%20click%20pop-up%20menu%20stopped%20working%20in%20Excel%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-204703%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20using%20Excel%20for%20a%20long%20time.%20Since%202%20days%20(probably%20I%20did%20some%20wrong%20shortcut%20key%20combination%3F%3F)%20I%20cannot%20open%20pop-up%20menu%20with%20right%20click%20of%20the%20mouse.%3C%2FP%3E%3CP%3ERight%20click%20works%20everywhere%20in%20the%20menus%20and%20icons%20of%20Excel%2C%20even%20if%20I%20select%20full%20row%20or%20column%20still%20works%2C%20but%20in%20the%20area%20where%20are%20all%20cells%20it%20is%20not%20functional.%20Independent%20if%20it%20is%20existing%20excel%20book%20or%20new%20one.%20Still%2C%20if%20I%20open%20new%20Macro%20sheet%20within%20the%20book%2C%20it%20works%20there.%3C%2FP%3E%3CP%3EI%20tried%20restarting%2C%20also%20found%20few%20tips%26nbsp%3Bto%20write%20in%20VB%20some%20commands%2C%20but%20still%20no%20effect!%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20any%20support%20solving%20this%20annoying%20problem!%3C%2FP%3E%3CP%3EEmil%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-204703%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-451896%22%20slang%3D%22en-US%22%3ERe%3A%20Mouse%20right%20click%20pop-up%20menu%20stopped%20working%20in%20Excel%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-451896%22%20slang%3D%22en-US%22%3EHi%20Jan%2C%3CBR%20%2F%3EIt%20is%20worked%20on%20that%20current%20excel%20file%20when%20you%20do%20the%20vba%20editor.%20When%20I%20close%20it%20or%20open%20different%20excel%20file%2C%20the%20right%20click%20still%20not%20functioning.%20Please%20advise.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205127%22%20slang%3D%22en-US%22%3ERe%3A%20Mouse%20right%20click%20pop-up%20menu%20stopped%20working%20in%20Excel%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205127%22%20slang%3D%22en-US%22%3EYou're%20welcome!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-205095%22%20slang%3D%22en-US%22%3ERe%3A%20Mouse%20right%20click%20pop-up%20menu%20stopped%20working%20in%20Excel%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-205095%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%2C%20Jan%20Karel!%3C%2FP%3E%3CP%3ESecond%20suggestion%20worked!%20And%20I%20tried%20different%20suggestions%20I%20found%2C%20but%20only%20this%20one%20worked%20for%20me!%3C%2FP%3E%3CP%3EHave%20a%20great%20week!%3C%2FP%3E%3CP%3EEmil%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-204732%22%20slang%3D%22en-US%22%3ERe%3A%20Mouse%20right%20click%20pop-up%20menu%20stopped%20working%20in%20Excel%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-204732%22%20slang%3D%22en-US%22%3EOpen%20the%20VBA%20editor%20(alt%2BF11)%2C%20press%20control%2Bg.%20Type%20this%20text%3A%3CBR%20%2F%3EApplication.CommandBars(%22Cell%22).Reset%3CBR%20%2F%3EAt%20the%20end%20of%20that%20line%2C%20press%20enter.%3CBR%20%2F%3EIf%20that%20does%20not%20help%2C%20repeat%20the%20above%20with%3A%3CBR%20%2F%3EApplication.CommandBars(%22Cell%22).enabled%3Dtrue%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-452424%22%20slang%3D%22en-US%22%3ERe%3A%20Mouse%20right%20click%20pop-up%20menu%20stopped%20working%20in%20Excel%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-452424%22%20slang%3D%22en-US%22%3ESounds%20as%20if%20there%20is%20an%20add-in%20which%20changes%20the%20right-click%20menu.%20Check%20which%20add-ins%20you%20have%20installed%20(File%2C%20Options%2C%20Add-ins%20tab%2C%20select%20either%20Excel%20add-ins%20or%20COM%20add-ins%20from%20the%20drop-down%20and%20click%20Go).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-452758%22%20slang%3D%22en-US%22%3ERe%3A%20Mouse%20right%20click%20pop-up%20menu%20stopped%20working%20in%20Excel%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-452758%22%20slang%3D%22en-US%22%3EHi%20Jan%20Karel%2C%20I%20got%20checked%20the%20excel%20and%20COM%20add-ins%20but%20none%20of%20it%20is%20ticked.%20Update%20%3A%20The%20user%20feedback%20to%20me%20that%20now%20his%20excel%20are%20okay%2C%20but%20we%20still%20do%20not%20know%20why%20it%20is%20become%20like%20that.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-452972%22%20slang%3D%22en-US%22%3ERe%3A%20Mouse%20right%20click%20pop-up%20menu%20stopped%20working%20in%20Excel%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-452972%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F321059%22%20target%3D%22_blank%22%3E%40Ameer_manan%3C%2FA%3E%20This%20may%20be%20caused%20by%20any%20(COM%20or%20Excel)%20add-in%20or%20by%20a%20%22normal%22%20Excel%20workbook.%20Either%20of%20those%20may%20contain%20%3CSPAN%20style%3D%22display%3A%20inline%20!important%3B%20float%3A%20none%3B%20background-color%3A%20%23ffffff%3B%20color%3A%20%23333333%3B%20cursor%3A%20text%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3EVB(A)%20or%20RibbonX%20code%20which%20modifies%20the%20menus.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Emil Garnev
New Contributor

Hello,

I am using Excel for a long time. Since 2 days (probably I did some wrong shortcut key combination??) I cannot open pop-up menu with right click of the mouse.

Right click works everywhere in the menus and icons of Excel, even if I select full row or column still works, but in the area where are all cells it is not functional. Independent if it is existing excel book or new one. Still, if I open new Macro sheet within the book, it works there.

I tried restarting, also found few tips to write in VB some commands, but still no effect! 

Thank you for any support solving this annoying problem!

Emil

7 Replies
Solution
Open the VBA editor (alt+F11), press control+g. Type this text:
Application.CommandBars("Cell").Reset
At the end of that line, press enter.
If that does not help, repeat the above with:
Application.CommandBars("Cell").enabled=true

Thank you, Jan Karel!

Second suggestion worked! And I tried different suggestions I found, but only this one worked for me!

Have a great week!

Emil

 

 

Hi Jan,
It is worked on that current excel file when you do the vba editor. When I close it or open different excel file, the right click still not functioning. Please advise.
Sounds as if there is an add-in which changes the right-click menu. Check which add-ins you have installed (File, Options, Add-ins tab, select either Excel add-ins or COM add-ins from the drop-down and click Go).
Hi Jan Karel, I got checked the excel and COM add-ins but none of it is ticked. Update : The user feedback to me that now his excel are okay, but we still do not know why it is become like that.

Thank you

@Ameer_manan This may be caused by any (COM or Excel) add-in or by a "normal" Excel workbook. Either of those may contain VB(A) or RibbonX code which modifies the menus.

Related Conversations
Mouse Scroll stopped working
Front Office in Access on
2 Replies
Mouse Horizontal Scroll Support
Bradley_Guy in Excel on
0 Replies