How to hide the status bar in Microsoft Excel with the VBA Code?

Published on October 21, 2016 by abundantcode

Filed under Excel

Last modified October 21, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 1108 times

Do you want to hide the status bar in Microsoft Excel ?. You can use the VBA code to do it quickly.


How to hide the status bar in Microsoft Excel with the VBA Code?

1. Open the excel workbook in Microsoft Excel 2016 and press the keyboard shortcut key “Alt + F11” to open the Microsoft Visual Basic for Applications window.

2. Click the “Insert –> Module” option from the menu and paste the following code.

Sub Hide()
    Application.DisplayStatusBar = False
End Sub

3. Press F5 to run the module. This would hide the StatusBar in the page. To display the StatusBar back, change the value False to True and press F5.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Comment


You might be Interested in these Posts

Example for Declarative vs. Imperative Style Code in C#

Are you looking out for an example of declarative vs imperative style code in c# ? . Below is a samp...

Tools to Convert Java to C# Source Code

There are times when a developer would have done a project using Java and would want to reuse some o...

PHP Code Refactoring Tools

Here's a list of some of the Refactoring tools for the PHP developers.PHP Code Refactoring Tools...