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.....
What should i change in order for excel to uncheck all of the checkbox on every sheets with checkbox in?![]()
Sub UncheckAll() Dim ChkBox As Excel.CheckBox For Each ChkBox In ActiveSheet.CheckBoxes ChkBox.Value = xlOff Next ChkBox NextScreening End Sub
BRgds
C.Y.Chua
Bookmarks