Thread: Excel Check Box
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Greg Wilson Greg Wilson is offline
external usenet poster
 
Posts: 747
Default Excel Check Box

I believe both your's and Anne's methods will only work for native drawing
objects and not for ActiveX controls. The OP's check box is likely an ActiveX
control. I went to my own web account and copied a check box and pasted it to
the worksheet. I could not activate the control using either your's or Anne's
methods.

Best regards,
Greg



"STEVE BELL" wrote:

Another way is to select the "Select Objects" arrow from the Drawing
toolbar.
Encircle all the object such that each is selected.
Than click "Delete".

--
steveB

Remove "AYN" from email to respond
"Greg Wilson" wrote in message
...
Try this:
1) Select ViewToolbarsControl Toolbox.
2) Activate the Design Mode control at the top-left corner of the toolbar
(the tool tip should say "Design Mode").
3) Hold the mouse pointer over the check box. It should turn into a
four-way
arrow. 4) Select the check box.
4) Click the <Delete button.

Regards,
Greg

"Shady Lady" wrote:

I copied a couple of lines from one of my accounts on line. I mistakenly
copied a form field (a check box). I can't remove the box. I have tried
to
delete the whole row. I have done clear contents. I have changed the
cell
formatting. I don't know what else to do. When I delete the row it
moves to
the next row.
--
Shady