I have a protected worksheet with unlocked cells and a small section of check boxes. I have a "clear form" button that clears the unlocked cells however, it does not clear the check boxes. What can I add to the code below that will clear the check boxes too?
Sub ClearUnlockedCells() Application.FindFormat.Clear
Application.FindFormat.Locked = False
Cells.Replace "*", "", SearchFormat:=True, ReplaceFormat:=False
Application.FindFormat.Clear
End Sub
Thank you,
a101244
Sub ClearUnlockedCells() Application.FindFormat.Clear
Application.FindFormat.Locked = False
Cells.Replace "*", "", SearchFormat:=True, ReplaceFormat:=False
Application.FindFormat.Clear
End Sub
Thank you,
a101244