Why are the Edit, Insert and Format menus greyed out in Excel?
 

Lately, when I open any files in Excel, the Edit, Insert and Format menus are
always grayed out. I am unable to access these functions in my Excel files.

For your information, this happens when I open any file in Excel.

How do I restore Excel back to its original condition?

It's possible to switch the menus off in VBA, maybe you have run a workbook
that has done that as part of a protection routine, and it hasn'r re-enabled
them after exiting.
You may have also saved your standard Excel template with the code to do
this, so that's why it happens everytime.

write some VBA code with the follownig lines, and then execute it to see if
that works.

Commandbars("Worksheet Menu Bar").Controls("Edit").Enabled = True
Commandbars("Worksheet Menu Bar").Controls("Insert").Enabled = True
Commandbars("Worksheet Menu Bar").Controls("Format").Enabled = True

HTH

Neil

"Simon Lim" wrote:

Lately, when I open any files in Excel, the Edit, Insert and Format menus are
always grayed out. I am unable to access these functions in my Excel files.

For your information, this happens when I open any file in Excel.

How do I restore Excel back to its original condition?

It might be simpler to just reset the worksheet menubar.

Tools|Customize|Toolbars tab
select worksheet menu bar
hit the reset button.

If you've customized this toolbar, you'll have to do it again.

Simon Lim wrote:

Lately, when I open any files in Excel, the Edit, Insert and Format menus are
always grayed out. I am unable to access these functions in my Excel files.

For your information, this happens when I open any file in Excel.

How do I restore Excel back to its original condition?

--

Dave Peterson