How to delete a checkbox on a Excel sheet ?

[Gilbert Tordeur]

Hello,

I am using Excel 2003. I have created a template (.xlt) with some
checkboxes. No macro in the template. No action related to the checkbox
(only for printing).

I would like to delete these checkboxes now but I cannot go back to the
design mode. Whenever I click on a checkbox (left or right), it does nothing
but check the box !

How can I do ?

Thank you in advance,
Gilbert

 

[Jim Rech]

You have to be in design mode to select/delete the check boxes. Switch to
the VBE (Alt-F11) and click the Design Mode button on the Standard toolbar.
Then come back to Excel.

--
Jim
| Hello,
|
| I am using Excel 2003. I have created a template (.xlt) with some
| checkboxes. No macro in the template. No action related to the checkbox
| (only for printing).
|
| I would like to delete these checkboxes now but I cannot go back to the
| design mode. Whenever I click on a checkbox (left or right), it does
nothing
| but check the box !
|
| How can I do ?
|
| Thank you in advance,
| Gilbert
|
|

 

[Don Guillett]

try this
Sub nocheckboxes()
ActiveSheet.CheckBoxes.Delete
End Sub

 

[Gilbert Tordeur]

Wonderful Jim,

Thank you for your help,
Gilbert

(Thanks also to Don, but I did not need to try his solution)