'Uncheck button'
 

I've made an 'uncheck button' within Excel... I want this button to remove
all checkboxes on the page. How would I go about doing this? There are 112
checkboxes in which the button would need to remove.

'Uncheck button'
 

Sub ClearCheckBoxes()
Dim ChkBox As Object
For Each ChkBox In ActiveSheet.CheckBoxes
ChkBox.Delete
Next ChkBox

End Sub


Regards,
Ryan---
--
RyGuy


"FuriaRi0T" wrote:

I've made an 'uncheck button' within Excel... I want this button to remove
all checkboxes on the page. How would I go about doing this? There are 112
checkboxes in which the button would need to remove.