Clear all form checkboxes...not working

[Rolaids24]

I found the following formula, but it doesn't seem to work to clear all the checkboxes on sheet 'Nonvisits' (where the button is located on K2). Any advice to make all the form checkboxes false?
Thanks!

[Logit]

Try this in a regular module :

Please Login or Register  to view this content.

[Rolaids24]

Thanks, but no it just does nothing at all when ran.

[RhiSJ]

Try this code, but it blows out all formats in the cells.

Please Login or Register  to view this content.

[Rolaids24]

Well that definitely does exactly what you said, RhiSJ, but clearing the checkboxes away is certainly not ideal. The point is someone with little excel knowledge can use the checkbox and then clear it for use again later. Is there no way to just set those cells (B6:B103 and K6:K103) to false?

[RhiSJ]

If you want reset the checkbox,

Please Login or Register  to view this content.

If you want to remove the cellcontrols.

Please Login or Register  to view this content.

[Rolaids24]

This did it! Thanks!

Please Login or Register  to view this content.