Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
popup menu commandbar
I would like to dissable the popup menus that appear when I right-click on a
row or cell on a Worksheet. I have been successful at disabling the row one with: Application.CommandBars("Row").Enable = False I used a similar line for the 'Cell' menu. My problem is that I'm still getting a menu when I right-click on a cell. Does anyone know what the menu is or name of this menu. Thanks Ed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
popup menu commandbar
Here are the right click menus
Application.CommandBars("PLY").Enabled = False 'Sheet Tabs Application.CommandBars("Row").Enabled = False 'Row Application.CommandBars("Column").Enabled = False 'Column Application.CommandBars("Cell").Enabled = False 'Cell -- HTH... Jim Thomlinson "Edward" wrote: I would like to dissable the popup menus that appear when I right-click on a row or cell on a Worksheet. I have been successful at disabling the row one with: Application.CommandBars("Row").Enable = False I used a similar line for the 'Cell' menu. My problem is that I'm still getting a menu when I right-click on a cell. Does anyone know what the menu is or name of this menu. Thanks Ed |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
popup menu commandbar
Hi Ed,
Try: Application.CommandBars("Cell").Enabled=False -- Regards, Norman "Edward" wrote in message ... I would like to dissable the popup menus that appear when I right-click on a row or cell on a Worksheet. I have been successful at disabling the row one with: Application.CommandBars("Row").Enable = False I used a similar line for the 'Cell' menu. My problem is that I'm still getting a menu when I right-click on a cell. Does anyone know what the menu is or name of this menu. Thanks Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Popup Menu / Shortcut Menu | Excel Discussion (Misc queries) | |||
positioning the control on a popup commandbar | Excel Programming | |||
Popup commandbar and Setfocus | Excel Programming | |||
Password on Commandbar menu list | Excel Programming | |||
How to force repaint of popup commandbar? | Excel Programming |