Forum Discussion
Excel - How to remove "Search the menus" in right-click menu options
The VBA code to remove an item from the Cell right-click menu is only one line.
A possible catch is that the name of the item to remove must match exactly with what appears on the menu.
And, and, and any character that is underlined in that items name must have the "&" sign in front it.
So the code is...
'---
Sub RelievePain()
Application.CommandBars("Cell").Controls("Search the Menus").Delete
End Sub
'---
The control name in the above must have the "&" sign entered (no quote marks)
As I dont have the control on my excel version, it is up to you to place it properly.
Matching the case of the characters on the menu should also be done.
'---
Nothing Left to Lose
https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU
(free excel programs)
That was a a tip in the right direction, BUT I have listed all Application.CommandBars and there is no "Search the menus" entry. I have also tried MenuRighter with the same result. (About the & sign issue, I looked at the menu entries one by one instead of searching).
It seems "Search the menus" is hidden somewhere else.
Microsoft® Excel® for Microsoft 365 MSO (Version 2211 Build 16.0.15831.20220) 32-bit
No luck removing it but I found workaround for now. Pressing "tab" key on the keyboard moves the cursor out of the search box so one can use shortcut keys again.
This change to the context menu is ridiculous. There must be an opt-out in the Advanced Preferences coming. I was going to say, "Frankly, anyone who doesn't know ctrl-f can search the document, isn't using the Shift-F10 context menu," but then I realized a lot of people right-click on the cells and look for the options. Who's going to right-click on a cell to search the whole document? Does that really happen? To people who have been using shortcuts with muscle memory for years, we need to be able to get rid of the search option. Or make it a tool in the list that you've got to click to engage.
This is the worst update feature I have experienced in my 25 years of using Excel. They kept shortcuts to the Edit menu, but obfuscated the shortcuts in the active context menu. I don't get it. This may sound pedantic, but I'm not a programmer who makes a change based on some brainstorming work session where we all dream about what the customer wants; I actually use this tool, and it just got bent.
