Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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)


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ScreenUpdating=False doesnt stop screen flicker?? Simon Lloyd[_703_] Excel Programming 5 March 24th 06 08:05 AM
Making sheets visible / hidden Xlyr Excel Programming 1 March 6th 05 07:45 PM
Making sheets visible and hidden to users Xlyr Excel Programming 1 March 6th 05 07:43 PM
Button flicker with screenupdating Mark Anders via OfficeKB.com Excel Programming 3 February 6th 05 12:23 PM
Application.ScreenUpdating = False and it still flicker ! Gunnar Johansson Excel Programming 5 September 8th 04 02:42 PM


All times are GMT +1. The time now is 08:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"