ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ScreenUpdating and making Sheets Visible - flicker? (https://www.excelbanter.com/excel-programming/364760-screenupdating-making-sheets-visible-flicker.html)

Gordon Smith \(eMVP\)

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