|
-
Jul 13th, 2011, 01:13 PM
#1
Thread Starter
Member
[Excel VBA] Status Bar Updating
I'm looking for ways to speed up my program, and one I found was to set
Code:
Application.DisplayStatusBar = False
which stops displaying the status bar. But, though it's not displayed, do you know if it still updates? I know there is another property
Code:
Application.StatusBar
Setting that to False means Excel has control and updates it like normal, setting it to any other string displays that string, and Excel no longer has control.
So, again, my question is, if I hide the status bar, is it still updating? It seems the second option might be better for speeding up code, i.e., Application.StatusBar = "Not updating" and then back to normal after the program is over.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|