View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Anders via OfficeKB.com Mark Anders via OfficeKB.com is offline
external usenet poster
 
Posts: 2
Default Button flicker with screenupdating

Hello all,

I have the following problem I hope someone will be able to help me with.
I have a program that hiddes/unhiddes different rows of an excel database.
In order to avoid annoying flicker I have set the "screenupdate=false" at
the beginning of the macro and back to "true" when it has completed. This
works fine.
However a Button and a Textbox also located on the sheet (outside the
scroll area) do continues to flicker.
Is there anyway to prevent this from happening? Thankx so much for sharing
you knowledge.

Mark A

--
Message posted via http://www.officekb.com