Flashing screen even with Application.ScreenUpdating = False

Posted to microsoft.public.excel.programming

Claus Busch Claus Busch is offline

external usenet poster

Posts: 3,872

Flashing screen even with Application.ScreenUpdating = False

Hi Bobby,

Am Sat, 10 Nov 2012 09:31:55 -0800 (PST) schrieb Bobby:

Application.ScreenUpdating = False

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

try:
With Sheets("Selection")
If .Visible = False Then .Visible = True
Application.Goto .Range("A1")
End With

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

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 01:26 PM.

Menu

About Us