CHANGE RIGHT CLICK OPTIONS
 

Hi
In Excel 2003, the right click options list includes a research option that
pops up on me routinely. It's very irritating, esp. if I am just about to
paste something because once the research window opens the paste option is
also gone and must copy again. Any way to turn this off or remove from
right-click menu?
Thanks!!

CHANGE RIGHT CLICK OPTIONS
 

Only possible with VBA


If I have the correct number this will disable the option
Run the macro one time

Sub test()
On Error Resume Next
Application.CommandBars("Cell").FindControl(ID:=73 43).Enabled = True
On Error GoTo 0
End Sub



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"gams sb" <gams wrote in message ...
Hi
In Excel 2003, the right click options list includes a research option that
pops up on me routinely. It's very irritating, esp. if I am just about to
paste something because once the research window opens the paste option is
also gone and must copy again. Any way to turn this off or remove from
right-click menu?
Thanks!!

CHANGE RIGHT CLICK OPTIONS
 

Oops

Must be False instead of True in the code


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
Only possible with VBA


If I have the correct number this will disable the option
Run the macro one time

Sub test()
On Error Resume Next
Application.CommandBars("Cell").FindControl(ID:=73 43).Enabled = True
On Error GoTo 0
End Sub



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"gams sb" <gams wrote in message ...
Hi
In Excel 2003, the right click options list includes a research option that
pops up on me routinely. It's very irritating, esp. if I am just about to
paste something because once the research window opens the paste option is
also gone and must copy again. Any way to turn this off or remove from
right-click menu?
Thanks!!