Status 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?
Status Bar  

Displays or hides the status bar. This is the 'strip' at the bottom of the Excel window. (Usually displaying 'ready').

The menu has a tick next to it when the status bar is visible.

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

 

Copyright Nick Hodge 2008. All Rights Reserved.