PDA

View Full Version : prevent shape flickering



d4vem
03-08-2012, 02:03 AM
When selecting any value in the filter (Column A) the embedded shape flickers in the worksheet. Is there anyway to prevent the shape from flickering. Please see attachment and thanks in advance for any solutions.

Jan Karel Pieterse
03-08-2012, 06:57 AM
This is caused by the page break lines showing, which can only be turned off by this little VBA commend:
ActiveSheet.DisplayPageBreaks = False

Paul_Hossler
03-08-2012, 08:25 AM
This is caused by the page break lines showing,


Learned something new .. thanks

Paul

d4vem
03-08-2012, 09:51 AM
Thanks for the reply however it is not a page break but a freeze pane

d4vem
03-08-2012, 12:11 PM
Aplogies its still not working

Jan Karel Pieterse
03-09-2012, 01:43 AM
I can confirm that turning off the freeze panes also seems to prevent the flicker of the shape. I see no way around this unfortunately.

d4vem
03-09-2012, 06:08 AM
I have turned off the freeze panes and the shape still flickers. I am using Excel 2007 if this may have any reason for the problem.

Kenneth Hobs
03-09-2012, 06:32 AM
I don't see the problem in your file using 2010.