Button flicker with screenupdating

[Mark Anders via OfficeKB.com]

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

 

[Guest]

Try selecting these objects then Format>Properties>Check Dont Move or Size
with cells

 

[Mark Anders via OfficeKB.com]

Thanks gocush.
Checked your suggestion but flicker remains. The buttons by the way are
located on part of the sheet that does not get hidden/unhidden and so do
not moved relative to the cells they sit on.

 

[Peter T]

Hi Mark,

A slight flick each time Screenupdating is set to true is often normal,
particularly if there are several objects on the sheet. Depends also on what
other changes are going on, it can be worse if an object is selected. Ensure
that Screenupdating is only reset once in the entire routine. If it's
changing many time in a loop you will get a lot of flicker.

Regards,
Peter T