Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ScreenUpdating not effective
Dear Experts,
Can you help me reduce uncontrolled screen updates ? The problem is that when the user moves the cursor to a column which is not shown on the screen, Excell immediately repositions the sheet and updates the screen. My macros catch the selection change and reposition the sheet in a special way, however that happens only after excel has updated the screen. None of the following seems to make a difference: With Application .ScreenUpdating = False .EnableEvents = False .Calculation = xlCalculationManual End With Is there hope ? ... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ScreenUpdating not effective
About the best you could do is use the ScrollArea setting to prevent the
user from positioning out of the visible range. Screenupdating setting is only effective in macros to the best of my knowledge. -- Regards, Tom Ogilvy Boaz Michaely wrote in message ... Dear Experts, Can you help me reduce uncontrolled screen updates ? The problem is that when the user moves the cursor to a column which is not shown on the screen, Excell immediately repositions the sheet and updates the screen. My macros catch the selection change and reposition the sheet in a special way, however that happens only after excel has updated the screen. None of the following seems to make a difference: With Application .ScreenUpdating = False .EnableEvents = False .Calculation = xlCalculationManual End With Is there hope ? ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
about screenupdating | Excel Discussion (Misc queries) | |||
Screenupdating Problems | Excel Discussion (Misc queries) | |||
What does ScreenUpdating = False do? | Excel Worksheet Functions | |||
unable to control screenupdating | Excel Programming | |||
screenupdating command ignored | Excel Programming |