PDA

View Full Version : 2007 title bar



av8tordude
08-06-2009, 08:51 AM
I have the code below that hides the menu bar and formula bar in 2003. What do I need to add to hide it in 2007?


Sub TitleBarClose()
On Error Resume Next
With Application
.CommandBars("Worksheet Menu Bar").Enabled = False
.DisplayFormulaBar = False
End With
On Error GoTo 0
End Sub

Sub TitleBarOpen()
On Error Resume Next
With Application
.CommandBars("Worksheet Menu Bar").Enabled = True
.DisplayFormulaBar = True
End With
On Error GoTo 0
End Sub

Paul_Hossler
08-06-2009, 04:36 PM
Well, you can hide the Ribbon using the CustomUI if you want to do that:


<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
</ribbon>
</customUI>


and hide the Formulabar


Private Sub Workbook_Open()
Application.DisplayFormulaBar = False
End Sub


Paul

Bob Phillips
08-07-2009, 05:48 AM
Dynamically



Application.SendKeys "^{F1}"