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