T
TWG
Can anyone help me to hide the title-bar in a workbook by means of code in
Excel 2007?
Excel 2007?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
TWG
Yes
Simon Lloyd skrev:
Simon Lloyd skrev:
What is it you mean by "Title Bar"? do you mean the bar that displays
"Book1 - Microsoft Excel"?
--
Simon Lloyd
Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
T
TWG
As you can see, I already have this command in the workbooks AUTO_OPEN - thus:
Sub auto_open()
With ActiveWindow
.DisplayGridlines = False
.DisplayHeadings = False
.DisplayZeros = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With
Application.DisplayFullScreen = True
End Sub
BUT - it does not make the title-bar invisuable
Simon Lloyd skrev:
Sub auto_open()
With ActiveWindow
.DisplayGridlines = False
.DisplayHeadings = False
.DisplayZeros = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With
Application.DisplayFullScreen = True
End Sub
BUT - it does not make the title-bar invisuable
Simon Lloyd skrev:
G
Gord Dibben
You are missing a few things.
Private Sub Auto_Open()
With ActiveWindow
.DisplayHeadings = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With
With Application
.DisplayStatusBar = False
.CommandBars("Worksheet Menu Bar").Enabled = False
.DisplayFullScreen = True
.DisplayFormulaBar = False
End With
End Sub
Don't forget to code to change reset when the workbook is closed.
Or you can use Thisworkbook Activate and Deactivate events as Simon points
out.
Gord Dibben MS Excel MVP
Private Sub Auto_Open()
With ActiveWindow
.DisplayHeadings = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With
With Application
.DisplayStatusBar = False
.CommandBars("Worksheet Menu Bar").Enabled = False
.DisplayFullScreen = True
.DisplayFormulaBar = False
End With
End Sub
Don't forget to code to change reset when the workbook is closed.
Or you can use Thisworkbook Activate and Deactivate events as Simon points
out.
Gord Dibben MS Excel MVP
T
TWG
Yes, I tried. The title-bar is still visible
Simon Lloyd skrev:
Simon Lloyd skrev: