[Home]] ](/danielep71/VBA-PERFORMANCE/wiki/[[Class-cPerformanceOptimizer)

---

1. Statement

Turn off the status bar while the code runs to improve performance.

2. Description

The status bar setting is separate from the screen updating setting so that you can still display the status of the current operation even while the screen is not updating.

Points to consider:

• make sure you don’t need to display the status of every operation;
• make sure you don’t want to display any progress bar in the status bar;
• in some situations, you may want the status bar to be visible.

3. How to use

If Application.DisplayStatusBar is set to False, Excel does not display the status bar.

After your code executes, restore the functionality to its original state.

• Application.DisplayStatusBar = False at the beginning of your code
• Application.DisplayStatusBar = True (or original state) before the ending of your code

4. Performance test

5. Results

6. Conclusions

I recommend hiding the status bar in virtually all your procedures.

---

[Home]] ](/danielep71/VBA-PERFORMANCE/wiki/[[Class-cPerformanceOptimizer)