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

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

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.

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

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

"Mark Anders via OfficeKB.com" wrote in message
...
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.

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