ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   can i delete "lookup" from right-click in excel 2003? (https://www.excelbanter.com/excel-worksheet-functions/14451-can-i-delete-%22lookup%22-right-click-excel-2003-a.html)

aarria

can i delete "lookup" from right-click in excel 2003?
 
Is there a way to edit what appears in my "right-click" function in Excel
2003? One of the options that appears in the right click option is "Lookup"
which is bringing up a research box. Can i delete this option from my right
click command?

Ron de Bruin

Yes you can do this with code

Application.CommandBars("Cell").FindControl(ID:=76 85).Enabled = False

See
http://www.rondebruin.com/menuid.htm





--
Regards Ron de Bruin
http://www.rondebruin.nl



"aarria" wrote in message ...
Is there a way to edit what appears in my "right-click" function in Excel
2003? One of the options that appears in the right click option is "Lookup"
which is bringing up a research box. Can i delete this option from my right
click command?





All times are GMT +1. The time now is 10:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com