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

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

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

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