Changing Microsoft Excel Status Bar

Maybe for some reason we want to change our Microsoft Excel Status Bar, then this simple vba function will do the work for us.

The end result will look like this:

changing microsoft excel status bar

Ok, to do it, put this following code in ThisWorkbook code

Private Sub Workbook_Open()
    'when workbook opened, change the status bar
    Application.StatusBar = "Changing Excel Status Bar | excelvbamacro.com"
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    'remove status bar info before workbook closed
    Application.StatusBar = False
End Sub

Now we can brag to our friends about our Excel status bar when we opened our Excel Workbook ;) )

This entry was posted in Excel VBA Function and tagged , , , . Bookmark the permalink.

6 Responses to Changing Microsoft Excel Status Bar

  1. Pingback: Fastest Way To Lose Weight

  2. Pingback: home reverse mortgages

  3. Pingback: reverse mortgage costs

  4. Pingback: air purifiers for home

  5. Pingback: wisdom teeth extraction

  6. Pingback: Calgary wedding photographer

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>