Excel 2016 vba application screenupdating false
So every time when I select any cell in that worksheet the screen flickers. Sometimes me too experienced that with Worksheet Events but adding that screenupdating = false code made it to flicker even more with the Worksheet Change Event.So I just stopped using screenupdating = false with worksheet events.
Calculation = xl Calculation Manual End Sub Public Sub TU_End() Application. Slicer Caches("Slicer_Sol Name1") Set sc5 = This Workbook. Slicer Caches("Slicer_Sol Name") Set sc4 = This Workbook. Screen Updating = False Call TU_End End Sub Sub Filter_Columns(s Header Range As String, s Report Sheet As String, s Pivot Sheet As String, s Pivot Name As String, s Pivot Field As String) Dim c As Range Dim r Col As Range Dim pi As Pivot Item Worksheets(s Report Sheet). Selected Next si7 On Error Go To 0 Call Filter_Columns("sol H", "Dashboard", "Pivot", "Sol PT", "Solution") Application. Hidden = False For Each c In Worksheets(s Report Sheet).