VBA - chart/screen flickering after xlSheetVisible = True

[Piotr Kalinowski]

I've got a problem and really need some help from you. I was trying to google the solution, but found nothing useful. My macro runs by clicking on a commandbutton1 which is located on sheet1. Important detail: a chart is also located on sheet1.

The only thing the macro does is switching sheet2 from 'hidden' to 'visible'.

Sub abc()

    Sheets(2).Visible = Not Sheets(2).Visible

End Sub

THE PROBLEM: after switching the sheet2 from hidden to visible the screen is flickering.

Notes:

1. The problem occurs only on the sheets with charts. It seems like excel is doing some chart update.
2. It occurs only when sheet2 is being switched to "visible".
3. I've tried:

   Application.EnableEvents = False
   Application.ScreenUpdating = False
   Application.DisplayStatusBar = False
   Application.Calculation = xlCalculationManual

1. I deleted any other macros and events in the workbook.
2. I've tried to run a macro directly from VBA editor (not via commandbutton1).
3. I've tried debugging step by step.

Is there anyone who can help me with this issue?

 

[rlv01]

1. The problem occurs only on the sheets with charts. It seems like excel is doing some chart update.
2. It occurs only when sheet2 is being switched to "visible".

It looks to me like excel does a screen refresh when a page becomes visible. Any sheet, not just the ones with shapes (a chart is also a shape). Even on an empty worksheet you can see the selected cell flicker briefly. It's just that it is more a lot more noticeable on sheets that have shapes on them because it looks like all shapes get repainted. I'm not sure there is much that can be done about that.