Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Overriding ScreenUpdate function Trevor Williams Excel Programming 4 September 8th 06 03:23 PM
100% cpu usage bill Excel Discussion (Misc queries) 1 March 2nd 06 10:27 AM
DisplayAlerts and ScreenUpdate will not set to False Joe at Baso New Users to Excel 1 April 5th 05 07:41 PM
Screen flicker despite ScreenUpdate = False in the first line of code Gunnar Johansson Excel Programming 6 September 3rd 04 02:05 PM
Unwanted freezed screen cause by screenupdate = false Graiman Excel Programming 3 July 1st 04 07:01 PM


All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"