| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Menus
I have some menus that I want to temporarily disable via VBA. That is, I
want the user to still be able to see all the menu sub-items, but I would like them to be greyed out and inactive. No I no I can comment our the code that is triggered by the menue items, but I also want to grey out the items too. How do I do this? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling Menus
I would suspect you would have to loop through the lowest level controls and
set the enable property to false. -- Regards, Tom Ogilvy "ExcelMonkey" wrote in message ... I have some menus that I want to temporarily disable via VBA. That is, I want the user to still be able to see all the menu sub-items, but I would like them to be greyed out and inactive. No I no I can comment our the code that is triggered by the menue items, but I also want to grey out the items too. How do I do this? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling Menus
See
http://www.rondebruin.com/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "ExcelMonkey" wrote in message ... I have some menus that I want to temporarily disable via VBA. That is, I want the user to still be able to see all the menu sub-items, but I would like them to be greyed out and inactive. No I no I can comment our the code that is triggered by the menue items, but I also want to grey out the items too. How do I do this? Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling Menus
Set the control's Enabled property to False.
-- Jim "ExcelMonkey" wrote in message ... |I have some menus that I want to temporarily disable via VBA. That is, I | want the user to still be able to see all the menu sub-items, but I would | like them to be greyed out and inactive. No I no I can comment our the code | that is triggered by the menue items, but I also want to grey out the items | too. How do I do this? | | Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sub-menus of main menus for Excel 2007 | New Users to Excel | |||
| difference between word 2003 menus and word 2007 menus-Explain pl | Excel Discussion (Misc queries) | |||
| New Menus - attaching but menus are reset | Excel Worksheet Functions | |||
| Disabling menus etc | Excel Programming | |||
| Overriding Actions of Excel DropDown Menus and Poup Menus | Excel Programming | |||
Linear Mode
