Excel VBA Macro

Changing Microsoft Excel Status Bar

Posted on the September 10th, 2008 under Excel VBA Function by Poer @ Excel VBA/Macro

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 )

Related Entries

• Automatically Run an Excel Macro
• Check If Excel Workbook is Already Open or Not
• Finding Cell with Minimum/Maximum Value in Active Worksheet
• Schedules to Refresh Data Automatically using VBA Macro
• How To Open Excel File Using Macro

External Resources

• Microsoft Excel 2003/2007 Video Tutorials

  Step-by-step video guide to mastering Charts, PivotTable, Data Analysis and Macro programming in Microsoft Excel in 5 hours.

• 101 Secrets of Microsoft Excel

  Discover 101 of Excels little-known secrets that have been hiding right under your nose.

Tagged with: status bar, vba function, vba macro