Formula Bar

Home Search Site Map

Up
Comments
Custom Views...
Formula Bar
Full Screen
Header & Footer...
Normal
Page Break Preview
Status Bar
Task Pane
Toolbars
Zoom...

New! Excel User Group Now Open @ www.excelusergroup.org, Check It Out!


Menu command Type What happens next?
Formula Bar  

Toggles between showing the formula bar (and the name box) and not.  This menu item is ticked when the formula bar is showing

Sub ShowFormulaBar()
'Toggles the setting to the opposite of current
With Application
If .DisplayFormulaBar = True Then
.DisplayFormulaBar = False
Else
.DisplayFormulaBar = True
End IfIf
End With
End Sub

 

Copyright Nick Hodge 2008. All Rights Reserved.