View Full Version : prevent shape flickering

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

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

Learned something new .. thanks


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

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.

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.