Is this faster?
![]()
Option Explicit Sub Check_Box() Dim i As Long With Application .Calculation = xlCalculationManual .ScreenUpdating = False .EnableEvents = False End With With Sheets("Filters") If .Shapes("Check Box 42").ControlFormat.Value = 1 Then For i = 43 To 76 .Shapes("Check Box " & i).ControlFormat.Value = True Next i Else For i = 43 To 76 .Shapes("Check Box " & i).ControlFormat.Value = False Next i End If End With With Application .Calculation = xlCalculationAutomatic .EnableEvents = True .ScreenUpdating = True End With End Sub
Bookmarks