Hello- I'm trying to get excel to hide my menu bar and all the tabs in Excel 2003. To do so, I'm using the following VBA:
On Error Resume Next
With Application
.DisplayFullScreen = True
.CommandBars("Full Screen").Visible = False
.CommandBars("MyToolbar").Enabled = True
.CommandBars("MyToolbar").Visible = True
.CommandBars("Worksheet Menu Bar").Enabled = False
End With
On Error GoTo 0
The problem is that when I active this, excel grows beyond the bottom of my screen and I can't see the tabs at the bottom of the workbook.
Any advice?
Thanks!
Bookmarks