Hi,
I have the code below with the usual Application.ScreenUpdating incorporated but the screen still flashes/flickers when the code runs - everything (charts/tables etc.) momentarily disappear and re-appear when it runs so it doesn't look very slick. The page has a couple of charts reading from other sheets, some tables with formulas, text boxes reading from other sheets and some combo boxes being used as dropdowns. I'm using Excel 2016.
Any thoughts?
I have the code below with the usual Application.ScreenUpdating incorporated but the screen still flashes/flickers when the code runs - everything (charts/tables etc.) momentarily disappear and re-appear when it runs so it doesn't look very slick. The page has a couple of charts reading from other sheets, some tables with formulas, text boxes reading from other sheets and some combo boxes being used as dropdowns. I'm using Excel 2016.
Any thoughts?
Code:
Private Sub ComboBox7_Change()
On Error GoTo errHandle:
Application.ScreenUpdating = False
Sheet8.Unprotect Password:="pass1"
Sheet17.Visible = True
Call Macro41
Sheet17.Visible = xlVeryHidden
Sheet8.Select
Range("R22").Select
Sheet8.Protect Password:="pass1"
Application.ScreenUpdating = True
errHandle:
End Sub