LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 389
Default ScreenUpdating

I have used ScreenUpdating = False in certain instances. My issue is that in
a certain file I am trying to get to a certain cell in the worksheet and have
a certain screen setup after the macro(s) run. (In this instance it is that
the cursor be on the selected row based on criteria and be the 3rd row that
shows under the Windows/FreezeFrame rows). The only way I have been able to
resolve my issue is that at certain points in the Macro(s) I have to set the
ScreenUpdating back to True and then back to False. I can get the desired
result doing this but when I do this I also have some flickers occuring on in
the screen. The flickering is not that bad but I would prefer a totally
smooth transition. Is there any way that I can stop these flickers and
totally freeze the screen until the macro(s) have completed and get my
desired results of the desired screen postioning.

Thank you for your help.

Steven
 
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
about screenupdating baha Excel Discussion (Misc queries) 0 March 25th 10 06:16 AM
ScreenUpdating Paul Excel Programming 2 March 8th 06 10:16 PM
App.screenupdating Steph[_3_] Excel Programming 2 May 11th 05 10:39 PM
When to use screenupdating? augustus Excel Programming 2 December 12th 04 09:21 PM
Screenupdating Fu Manchu Excel Programming 2 January 11th 04 02:08 PM


All times are GMT +1. The time now is 11:28 AM.

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

About Us

"It's about Microsoft Excel"