Hi All!
Having a lil problem on my code. For the current code i used now, it worked only on Sheet1 but not sheet2,3,4.....

Sub UncheckAll()
    Dim ChkBox As Excel.CheckBox
          
      For Each ChkBox In ActiveSheet.CheckBoxes
        ChkBox.Value = xlOff
      Next ChkBox
      NextScreening
End Sub
What should i change in order for excel to uncheck all of the checkbox on every sheets with checkbox in?

BRgds
C.Y.Chua