ExcelBanter

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

clara

ScreenUpdate Usage
 
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

Bill Renaud

ScreenUpdate Usage
 
Screen updating also occurs automatically as soon as all macros have
finished running.
--
Regards,
Bill Renaud





All times are GMT +1. The time now is 02:00 PM.

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