Application.DisplayStatusBar

The DisplayStatusBar property allows you to stop updating the status bar.
If you use VBA to copy/paste a range, while the paste is completing Excel will show the progress of that operation in the status bar.
This property works independently from the ScreenUpdating property.
It is possibele to turn off screen updating but still provide feedback to the user using the status bar.


Excel

Application.DisplayStatusBar = True 

Word

The property Application.DisplayStatusBar does not exist in Word.


PowerPoint

The property Application.DisplayStatusBar does not exist in PowerPoint.



© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext