View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
gocush[_29_] gocush[_29_] is offline
external usenet poster
 
Posts: 252
Default Button flicker with screenupdating

Try selecting these objects then FormatPropertiesCheck Dont Move or Size
with cells


"Mark Anders via OfficeKB.com" wrote:

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