How do you remove a check box (Control) in an Excel spreadsheet?

Z

zjan

I have a spreadsheet that is not "locked" and I want to remove an active -x
control feature ( a check box) I cannot cut or remove this "feature" form my
worksheet. Help does not provide any relief!

JJ
 
C

Chip Pearson

Be SURE the sheet is not protected. Then, open the Control
toolbar and click the "Design Mode" button (upper left). Then
click on the check box. You should be able to delete it then. If
not, you might try using VBA to delete the control.

In the Immediate window (CTRL+G to display), enter the following
and press Enter

ActiveSheet.OLEObjects("Checkbox1").Delete

Of course, change "Checkbox1" to the name of your control.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
B

Biff

Hi!

Open the Control Toolbox toolbar.

Click on the Design Mode icon

Click on the offending checkbox

Goto Edit>Clear>All

Exit Design mode

Close the toolbar

Biff
 
Top