Forum Discussion

Grant_King's avatar
Grant_King
Copper Contributor
Aug 10, 2022

Excel - How to remove "Search the menus" in right-click menu options

Hello all,   Just today I noticed when I right-clicked in an open Excel tab, the top-most option (normally "Cut") has been replaced by a search bar with "Search the menus" appearing in it automatic...
excel
Damien17's avatar
Damien17
Copper Contributor
Oct 13, 2022
I'm not a fan of this at all. It feels like it has been added to support general/basic excel users, unfortunately, they have discarded advanced users' UX. All they need to do is add an option to disable it. There is already a search bar at the top of the app and it already has a shortcut assigned... why the need to add it to a right click as well?!?!
  • Nothing_Left_to_Lose's avatar
    Nothing_Left_to_Lose
    Brass Contributor
    Oct 14, 2022

    Damien17 

     

    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)

    • hgitz_Guj's avatar
      hgitz_Guj
      Copper Contributor
      Jan 30, 2023

      Nothing_Left_to_Lose 

       

      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

      • JanyG's avatar
        JanyG
        Copper Contributor
        Jan 31, 2023

        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. 

Resources