Excel VBA: Hiding the Status Bar

This Excel VBA macro hides the Status bar.

Macro Example

Sub HideStatusBar()

  Application.DisplayStatusBar = False

End Sub

Description

Application

  Application...

The Application property returns an Application object.

obj-Excel-Global-Application

Application.DisplayStatusBar

  Application.DisplayStatusBar...

The Application.DisplayClipboardWindow property returns True if the status bar is displayed.

In this macro, we are setting to False so that the status bar is hidden.

Sub HideStatusBar()

  Application.DisplayStatusBar = False

End Sub

Properties

http://www.relief.jp/itnote/archives/003584.php

Apply to

  • Excel 2013
  • Excel 2010
  • Excel 2007