Flashing screen even with Application.ScreenUpdating = False

Posted to microsoft.public.excel.programming

Bobby[_4_] Bobby[_4_] is offline

external usenet poster

Posts: 53

Flashing screen even with Application.ScreenUpdating = False

I am trying to pivot and hide between 2 sheets and make it look professional.

Event with this code I get the flashing screen as soon as the sheet gets visible.
Is there an other option that I could use?

Application.ScreenUpdating = False

If Sheets("Selection").Visible = False Then Sheets("Selection").Visible = True
Sheets("Selection").Select

Thank's ahead.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Screen flikering (even with ScreenUpdating = False)	SpeeD	Excel Programming	0	February 20th 09 03:13 PM
Screen still changes. Why ? (Application.Screenupdating = False not working	Coza	Excel Programming	1	March 21st 07 03:47 AM
Application.ScreenUpdating = False still causing screen to flash...	[email protected]	Excel Programming	3	January 5th 07 05:10 AM
How to set Application.ScreenUpdating = False for Gen use	David_Williams_PG ()	Excel Discussion (Misc queries)	1	August 15th 06 12:06 PM
Application.screenUpdating = False	Pamhall	Excel Programming	1	December 17th 04 03:19 PM

All times are GMT +1. The time now is 05:26 PM.

Menu

About Us