View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
L. Howard L. Howard is offline
external usenet poster
 
Posts: 852
Default Delete CheckBoxes

Macro 1 deletes ALL checkboxes on the sheet.
Macro 1 errors out.

How do I delete checkboxes in a given range on the sheet, leaving the others intact?

Thanks,
Howard


Sub Delete_Checkboxes1()
ActiveSheet.CheckBoxes.Delete
End Sub

Sub Delete_Checkboxes2()
ActiveSheet.Range("A2:B10").CheckBoxes.Delete
End Sub