![]() |
ScreenUpdating and making Sheets Visible - flicker?
(the "eMVP" means I'm an MVP for the "embedded" group - not excel)
I have some code which hides or unhides 4 sheets and works fine. However, I am seeing too much happening on the screen when I unhide. What am I doing wrong? Code: Application.ScreenUpdating = False Sheets("Sheet2").Visible = True Sheets("Sheet3").Visible = True Sheets("Sheet4").Visible = True Sheets("Sheet5").Visible = True Application.ScreenUpdating = True If I'm turning "ScreenUpdating" off, why am I seeing a brief image of each sheet as it becomes visible? It's very quick - but noticable. Thanks -- Gordon Smith (eMVP) |
All times are GMT +1. The time now is 01:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com