Get menu back when totally gone
Get menu back when totally gone
(OP)
Hi,
I have a problem when I open excel, I only see the row and column headers and the cells. No menus and no toolbars. I know how to add or remove these when they are there, but I can't do that now. What do I do?
Thanks very much,
Adam
adamcwebb@yahoo.com
PS I can send you a file of what it looks like if need be.
I have a problem when I open excel, I only see the row and column headers and the cells. No menus and no toolbars. I know how to add or remove these when they are there, but I can't do that now. What do I do?
Thanks very much,
Adam
adamcwebb@yahoo.com
PS I can send you a file of what it looks like if need be.





RE: Get menu back when totally gone
Nonetheless, I made a spreadsheet with a single button on it called "show me the toolbars!" Clicking the button should make all the toolbars visible. The code is shown below (I'll email you the ss):
Private Sub CommandButton1_Click()
Dim MyBar
For Each MyBar In Toolbars
MyBar.Visible = True
Next
End Sub
RE: Get menu back when totally gone
Sub test()
Application.CommandBars("Worksheet Menu Bar").Visible = True
End Sub
RE: Get menu back when totally gone
RE: Get menu back when totally gone
Ivymike won this contest. The final code that ended up solving the problem was:
Sub test()
CommandBars("Worksheet Menu Bar").Enabled = True
CommandBars("Worksheet Menu Bar").Visible = True
End Sub
I guess you could use the reverse of the first line to get rid of the menu bar too. Thanks par060, but I tried alt+v, alt+f but none of them worked. The menu bar wasn't there at ALL.
Cheers,
Adam.