View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
pls123 pls123 is offline
external usenet poster
 
Posts: 121
Default Application.ScreenUpdate

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




"Per Jessen" wrote:

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

On 17 Jan., 03:48, pls123 wrote:
hi all is there any way to make a

Workbook.ScreenUpdate
or a
WorkSheet.ScreenUpdate

instead than a Application.ScreenUpdate ???

ty !!
paolo