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

G

Guest

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
 

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

Similar Threads

'Cannot insert object' message when I try to put a button on a worksheet 7
Check Box (Form Control) 1
Excel - prevent someone from clicking into certain cells 1
How to delete a drop down box in Excel 2007 1
How to insert a Check Box to a Microsoft Office Excel Spreadsheet. 1
remove excel from office professional 3
Remove a line 2
How do I get "PAGE 1" removed from an Excel spreadsheet? 2

Top