Application.ScreenUpdate

[pls123]

hi all is there any way to make a

Workbook.ScreenUpdate
or a
WorkSheet.ScreenUpdate

instead than a Application.ScreenUpdate ???

ty !!
paolo

 

[Per Jessen]

Hi

No I don't think so.

But what would you use it for ?

Usually you turn off screenupdating at the start of the macro and then
turn it on again before End Sub.

Regards,
Per

 

[pls123]

hi im trying with

thisWorkbook.screenUpdating = false

and it works..now im make test for cpu usage, with or without..
i need for multiple pages open simoultaneously...making tests..

with application.screenupdating there is continuous flickering with worst
cpu usage,
because each page makes change it down and up every cycle of computation..
bybyyy

 

[mudraker]

Screen flicker is usually caused by selecting different books, sheets
cells etc

Selcting anything is rarely required when using Vba/macros.

If you post your code it probally can be improve

--
mudrake

If my reply has assisted or failed to assist you I welcome you
Feedback.

www.thecodecage.co

 

[pls123]

hi mud !!..
i have no "selects" i my vba code by longtime !!!!! ))
with Application.ScreenUpdate = false, i notice a cpu overwork in my
multiple open workbook with looping macro...
if i use workbook.screenupdating = false
ther is no flickering at all..
but i don know if it is active...

what do you think ??