Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delay update of sheets
Hi all:
In excel VBA, is there a way to freeze the updating of the sheets, make all sort of changes, and then have it update by code? I am trying to make lots of changes, but the screen flickers, and it takes too long. I was hoping to delay the the update once I was done with all my changes. Thanks for all your help. Bob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delay update of sheets
add these to the beginning of your code Application.ScreenUpdating = False Application.Calculation = xlCalculationManual and these at the end Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True -- Gary "Bob" wrote in message ... Hi all: In excel VBA, is there a way to freeze the updating of the sheets, make all sort of changes, and then have it update by code? I am trying to make lots of changes, but the screen flickers, and it takes too long. I was hoping to delay the the update once I was done with all my changes. Thanks for all your help. Bob |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delay update of sheets
Thanks Gary.
"Gary Keramidas" wrote: add these to the beginning of your code Application.ScreenUpdating = False Application.Calculation = xlCalculationManual and these at the end Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True -- Gary "Bob" wrote in message ... Hi all: In excel VBA, is there a way to freeze the updating of the sheets, make all sort of changes, and then have it update by code? I am trying to make lots of changes, but the screen flickers, and it takes too long. I was hoping to delay the the update once I was done with all my changes. Thanks for all your help. Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I update links from .xls sheets to .xlms sheets | Excel Worksheet Functions | |||
How to update data from multiple sheets to one specific sheets | Excel Discussion (Misc queries) | |||
Cell update delay | Excel Worksheet Functions | |||
Update all Sheets | Excel Discussion (Misc queries) | |||
Long Time Delay To Update NewsGroup | Excel Programming |