Pages

▼

Friday, April 11, 2008

Hide Excel Status Bar / Show Excel Status Bar using VBA

Show/Hide Application Status bar using Excel VBA

Here is the simple way to hide/show the status bar in Excel

Sub Hide_Status_Bar()

Application.DisplayStatusBar = False


End Sub

Sub Show_Status_Bar()

Application.DisplayStatusBar = True


End Sub


Also you need to clear the contents of the status bar.

Sub Clear_Status_Bar()

Application.StatusBar = False

(or)

Application.StatusBar = ""

End Sub
at

3 comments:

  1. Anonymous5:39 AM

    excellent tools. thanks

    ReplyDelete
  2. Anonymous8:58 AM

    This is the only place on the internet I was able to get the answer I needed. Thank you. You saved me a ton of time. I can't believe MS made this so complicated in this version.

    ReplyDelete
  3. Unknown11:32 PM

    customized status bar is not hide (excel billow showed status bar)

    ReplyDelete