View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ewan7279 ewan7279 is offline
external usenet poster
 
Posts: 97
Default ScreenUpdate Usage

Hi Clara,

The screen will not update at all until you reset application.screenupdating
= True.

Cheers,
Ewan.

"clara" wrote:

Hi all,

I have a macro in the following layout

sub MyMacro()
application.screenupdating = false
...
FirstCall()

...

SecondCall()


end sub

if some statements in firstcall() or secondcall() will make screen flick, do
I have to put application.screenupdating =false inside each of them?

CLara
--
thank you so much for your help