Excel Menu Dissapeared
 

I lost my main menu and only have my toolbars left
visible. I created a custom menu items but I did it in
VBA so I can just re-run the macro. I just need to get
the default menu back.

I lost it by running this:

Sub test()
Set myMenuBar = CommandBars.ActiveMenuBar
With myMenuBar.Enabled = False
End With
End Sub

I tried to change Enabled to True but it didn't work.
I'm on Excel XP. Thanks.

Excel Menu Dissapeared
 

CommandBars("Worksheet Menu Bar").Enabled = True

--
Regards,
Tom Ogilvy


"dan" wrote in message
...
I lost my main menu and only have my toolbars left
visible. I created a custom menu items but I did it in
VBA so I can just re-run the macro. I just need to get
the default menu back.

I lost it by running this:

Sub test()
Set myMenuBar = CommandBars.ActiveMenuBar
With myMenuBar.Enabled = False
End With
End Sub

I tried to change Enabled to True but it didn't work.
I'm on Excel XP. Thanks.

Excel Menu Dissapeared
 

Right on worked in a second, Thanks alot!

-----Original Message-----
CommandBars("Worksheet Menu Bar").Enabled = True

--
Regards,
Tom Ogilvy


"dan" wrote in
message
...
I lost my main menu and only have my toolbars left
visible. I created a custom menu items but I did it in
VBA so I can just re-run the macro. I just need to get
the default menu back.

I lost it by running this:

Sub test()
Set myMenuBar = CommandBars.ActiveMenuBar
With myMenuBar.Enabled = False
End With
End Sub

I tried to change Enabled to True but it didn't work.
I'm on Excel XP. Thanks.


.