I lost the Worksheet Menu Bar

[tfreeman]

As I explained in a post below, I entered some code to hide the Excel menus and show my custom menu. In doing so, I can't figure out how to get the Worksheet Menu Bar to come back! If I right-click on a toolbar and select customize, Worksheet Menu Bar isn't even an option. PLEASE HELP!

 

[Mudface]

Does right-click -Customise- Reset bring it back OK?

 

[tfreeman]

No, that doesn't do it. It's also now gone from ALL of my workbooks, including new ones that I open.

 

[Smitty]

See if this helps:

<font face=Tahoma><SPAN style="color:#00007F">Sub</SPAN> UnHideCommandBars()
    <SPAN style="color:#00007F">Dim</SPAN> x <SPAN style="color:#00007F">As</SPAN> CommandBar
        <SPAN style="color:#00007F">For</SPAN> <SPAN style="color:#00007F">Each</SPAN> x <SPAN style="color:#00007F">In</SPAN> Application.CommandBars
        x.Enabled = <SPAN style="color:#00007F">True</SPAN>
    <SPAN style="color:#00007F">Next</SPAN>
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

Smitty

 

[tfreeman]

That's not working either. Could I have "broke" it permanently?

 

[Smitty]

Can you post the code that you used?

Smitty

 

[tfreeman]

There's the next problem. I deleted it, thinking that would solve the problem. It didn't.

 

[Smitty]

Maybe:

<font face=Tahoma><SPAN style="color:#00007F">Sub</SPAN> Reset()
    <SPAN style="color:#007F00">'   Disable</SPAN>
    <SPAN style="color:#007F00">'Application.CommandBars("Worksheet Menu Bar").Enabled = False</SPAN>
    <SPAN style="color:#007F00">'   Enable</SPAN>
    <SPAN style="color:#007F00">'Application.CommandBars("Worksheet Menu Bar").Enabled = True</SPAN>
    <SPAN style="color:#007F00">'   Reset</SPAN>
    Application.CommandBars("Worksheet Menu Bar").Reset
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

Although, you might need to recreate your code and reverse it if that doesn't work.

Smitty

 

[tfreeman]

That didn't fix it either. The menu bar isn't showing in any workbooks that I open. Could I have disabled it from Excel completely?

 

[Zack Barresse]

Perform this VBScript: http://www.vbaexpress.com/kb/getarticle.php?kb_id=78

Basically, close Excel, delete your toolbar file (.xlb), reopen Excel.


(Heya Smitty!! )