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

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 ??



"mudraker" wrote:


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 improved


--
mudraker

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

www.thecodecage.com
------------------------------------------------------------------------
mudraker's Profile: http://www.thecodecage.com/forumz/member.php?userid=18
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=51411