Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
about screenupdating | Excel Discussion (Misc queries) | |||
ScreenUpdating | Excel Programming | |||
App.screenupdating | Excel Programming | |||
When to use screenupdating? | Excel Programming | |||
Screenupdating | Excel Programming |