PC Review


Reply
Thread Tools Rate Thread

Delay update of sheets

 
 
Bob
Guest
Posts: n/a
 
      29th Sep 2008
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 With Quote
 
 
 
 
Gary Keramidas
Guest
Posts: n/a
 
      29th Sep 2008

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" <(E-Mail Removed)> wrote in message
news:ACCDE4BB-0137-470E-BA16-(E-Mail Removed)...
> 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 With Quote
 
Bob
Guest
Posts: n/a
 
      30th Sep 2008
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" <(E-Mail Removed)> wrote in message
> news:ACCDE4BB-0137-470E-BA16-(E-Mail Removed)...
> > 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I update links from .xls sheets to .xlms sheets June Microsoft Excel Worksheet Functions 2 21st Apr 2010 08:57 PM
How to update data from multiple sheets to one specific sheets Khawajaanwar Microsoft Excel Misc 4 15th Jan 2010 07:31 AM
Cell update delay Bob_hc Microsoft Excel Worksheet Functions 5 4th Jan 2010 03:21 PM
TOOL for delay of update... Windows XP General 1 25th Aug 2004 04:37 PM
Windows update delay =?Utf-8?B?Ym9iZnJvbWF0bA==?= Windows XP General 0 4th Jun 2004 02:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:19 PM.