Prevent Screen Flicker with Freeze Panes

I have an issue with bad screen flicker. The screen flicker itself happens when refreshing a page and updating content but only when the Freeze Panes option is set. Is there any way to prevent the screen flicker and still use Freeze Panes, e.g. some code that would disable the Freeze Panes when a new option is selected from a Combo Box and then re-enable the Freeze Pane option once the screen has fully refreshed?

The Freeze OPane is applied to cell A3.

Many thanks

Hi Hangman,

Please Login or Register  to view this content.

will set your freeze pane and

Please Login or Register  to view this content.

Will turn it off.

What event or other macro do you have in your workbook?

You might also try some combination of

Please Login or Register  to view this content.

Hi Marvin,

Please Login or Register  to view this content.

make zero difference to the screen flicker in this instance. Whilst I can use

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

to freeze and unfreeze panes, how would I do this in conjuction with a combo box that is simply designed to refresh some charts. There is currently no macro running. The combo box sits in 'above' the frozen pane and when an option is selected from the drop down it refreshes six charts but with freeze panes on there is the really bad screen flicker, when freeze panes is not on there is no screen flicker when selecting another option from the combo box.

Is there a way to combine the two, i.e. to disable the freze panes whilst a new option is selected from the combo box and then once the screen has refreshed for the freeze panes to be re-enabled?

Many thanks

Is the combo box in a userform on tied to a single cell on the worksheet?

If it is on the worksheet, you could use an Event Macro of OnChange to stop screenupdating. You might also might try turning off calculation also and see if this stops the flicker.

We really need a sample workbook to see what code (if any) and where the flicker happens to be much more help.

Hi Marvin,

I've attached a sample to demonstrate.

Note: The problem does not exist in Excel 2013, only Excel 2010. The screen flicker increases with the more charts/graphics that need to be refreshed.

The attached currently has cell A3 as the Frozen Pane, if you select options from the combo box drop down using Excel 2010 you will see the screen flicker as the page refreshes. If you then remove the Freeze Panes option, i.e. Unfreeze Panes you will see the screen flicker is no longer there.

I've tried all your above suggestions and none make any difference, so my next option is to try and find a way to 'Unfreeze Panes' whilst the user makes a selection from the combo box and then once the screen has refreshed the Freeze Panes is re-set using cell A3.

Many thanks