Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
(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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ScreenUpdating=False doesnt stop screen flicker?? | Excel Programming | |||
Making sheets visible / hidden | Excel Programming | |||
Making sheets visible and hidden to users | Excel Programming | |||
Button flicker with screenupdating | Excel Programming | |||
Application.ScreenUpdating = False and it still flicker ! | Excel Programming |