delete a checkbox

S

susanhull

How does one delete a checkbox? I added a checkbox (ActiveX control)
to a cell, and now I want to remove it. But when I select the cell and
hit the delete key, the checkbox remains. I've tried deleting the
column or row, but the checkbox simply moves to the next column or
row. Your help is much appreciated!
 
G

Gord Dibben

Open the Controlbox Toolbar then select the Design Mode icon.

Now select the checkbox and Edit>Clear>All


Gord Dibben MS Excel MVP
 
R

Rick Rothstein \(MVP - VB\)

If you don't already have it displayed, click View/Toolbars/Visual Basic on
the Excel menu and the click on the Design Mode icon (triangle, ruler,
pencil) on that Visual Basic toolbar. When in Design Mode, select the
CheckBox and then press the Delete key. When done, click the Design Mode
icon again to turn that mode off again.

Rick
 
S

susanhull

If you don't already have it displayed, click View/Toolbars/Visual Basic on
the Excel menu and the click on the Design Mode icon (triangle, ruler,
pencil) on that Visual Basic toolbar. When in Design Mode, select the
CheckBox and then press the Delete key. When done, click the Design Mode
icon again to turn that mode off again.

Rick






- Show quoted text -

Thanks, Rick. It worked.
 
S

susanhull

Open the Controlbox Toolbar then select the Design Mode icon.

Now select the checkbox and Edit>Clear>All

Gord Dibben MS Excel MVP





- Show quoted text -

Thanks for your expertise.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top