insert menu is dissabled
 

Hi All,
My "insert" menu is disabled thanks to a file which ran a macro. How can I
re-enable it or set my menus back to default status?

Many Thanks!!

insert menu is dissabled
 

You can try the following steps:

1) In Excel, press Alt + F11 to go to VB Editor
2) Press Ctrl + G to show the Immediate Pane.
3) In the Immediate Pane, type:
Application.Commandbars(1).reset
and press the Return key on your keyboard.
4) Close VB Editor.

Regards,
Edwin Tam

http://www.vonixx.com


"Shane" wrote:

Hi All,
My "insert" menu is disabled thanks to a file which ran a macro. How can I
re-enable it or set my menus back to default status?

Many Thanks!!

insert menu is dissabled
 

Tools=Customize

on the first tab, select Worksheet Menu Bar and hit Reset.

--
Regards,
Tom Ogilvy

"Shane" wrote in message
...
Hi All,
My "insert" menu is disabled thanks to a file which ran a macro. How can I
re-enable it or set my menus back to default status?

Many Thanks!!