Excel 2007/2010 – 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:

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  ;-) )