Thread: Disabling Menus
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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