View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Sub Menus disabled

Al-F11
Ctrl G
Type "CommandBars(1).Reset" and press Enter in the Immediate window

Alt Q to go back to Excel


--
Regards Ron de Bruin
http://www.rondebruin.nl



"yasser" wrote in message ...
Tools is disabled. Customize is disabled also. I only see the menus: File,
Edit, View, Insert, Format, Tools, Data, Window, Help.; But when I click on
them, the sub menus are all greyed out.

There has to be some code to enable all the submenus.

THanks,

Yasser

"Bob Phillips" wrote:

ToolsCustomizeReset

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"yasser" wrote in message
...
I accidently disabled all sub menus from the menu bar. How can I enable

them
back?
Please help.

Thanks,

Yasser