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

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

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