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 possible 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.
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext