ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ScreenUpdate Usage (https://www.excelbanter.com/excel-programming/395708-re-screenupdate-usage.html)

ewan7279

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



All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com