Loss of TITLE and MENU Bar

BlueDingo

New Member
Joined
Oct 19, 2009
Messages
42
Hello, I have lost both my Title and Menu Bar from Excel. Mind you it looks good but not practical.
After having tied to decipher it through Help, I came across this odd paragraph that has stumped me:
".... you can quickly add and remove buttons and menus on the menu bar<NBSP />— but you can't hide the menu bar".
Well somehow it hid itself?? and I'd like it back, any suggestions?
Thanks Folk.
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
How to use below code..
1. Press Alt+F11
2. Double click any of sheet in project explorer window.
3. Place the below code in blank are and
4. press F5.


Code:
Sub RestoreToolbars()
On Error Resume Next
With Application
.DisplayFullScreen = False
.CommandBars("MyToolbar").Enabled = False
.CommandBars("Worksheet Menu Bar").Enabled = True
End With
On Error GoTo 0
End Sub
 
Upvote 0
This may seem like a stupid question, but have you already tried ALT+V+U?
 
Upvote 0

Forum statistics

Threads
1,215,046
Messages
6,122,852
Members
449,096
Latest member
Erald

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top