| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dropdown Sub Menu
Is there any way to edit or remove the options available from the Sub menu
toolbar( The one that is available, when you right click a Cell in a worksheet.) It would be useful to have a shortened list of options. Thanking you in anticipation GJ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dropdown Sub Menu
Try this...
CommandBars("Cell").Controls("Cut").Delete 'To delete "Cut" CommandBars("Cell").Reset 'To reset everything in the sub menu -- Regards, Rocky McKinley "GJ" wrote in message ... Is there any way to edit or remove the options available from the Sub menu toolbar( The one that is available, when you right click a Cell in a worksheet.) It would be useful to have a shortened list of options. Thanking you in anticipation GJ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dropdown Sub Menu
Thanks Rocky! It all seems so simple when you know how.
"Rocky McKinley" wrote: Try this... CommandBars("Cell").Controls("Cut").Delete 'To delete "Cut" CommandBars("Cell").Reset 'To reset everything in the sub menu -- Regards, Rocky McKinley "GJ" wrote in message ... Is there any way to edit or remove the options available from the Sub menu toolbar( The one that is available, when you right click a Cell in a worksheet.) It would be useful to have a shortened list of options. Thanking you in anticipation GJ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select From dropdown and return another dropdown menu | Excel Discussion (Misc queries) | |||
| Dropdown menu help | Excel Worksheet Functions | |||
| filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
| Create Dropdown menu without using the Validation on the Data Menu | Excel Worksheet Functions | |||
| dropdown menu or Jump menu | Excel Discussion (Misc queries) | |||
Hybrid Mode
