How do I make a VBA macro run "silently" in the background?
June 9, 2016 6:39 PM   Subscribe

I have a macro in an excel sheet that successfully displays or hides tabs in the workbook based on the value in a particular cell. I'm pleased with this! There's a problem, though...

When the tabs are "unhidden", there's a brief lag. The screen is basically showing a split second of each newly visible tab. I would like for this to occur completely in the background, such that the user does not see anything other than new tabs appearing at the bottom of the workbook.

Is this possible?
posted by jefficator to Computers & Internet (1 answer total) 3 users marked this as a favorite
 
Try wrapping your hiding/showing code with:

Application.ScreenUpdating = False

... do yer thing here ...

Application.ScreenUpdating = True

posted by roosterboy at 7:21 PM on June 9, 2016 [7 favorites]


« Older How to help friend deal with break up   |   Selling Stuff to Strangers Long Distance Newer »
This thread is closed to new comments.