Just as an extra precaution I will add an experience I had a few times. Once
an ActiveX control is on the Excel worksheet it is tough to see very much
info about it -- or, for that matter, how many there might be in the same
spot. I once or twice found that I had to delete the same object about 20 or
so times and it did finally go away. Apparently, the creator of the web form
had done copy paste a zillion times with the same object type in the same
spot.

On a true form, one could check the object drop down to see what items are
on the form, I don't think there is an equivalent in an Excel worksheet (or
at least I don't know where it is, if there is one.

"STEVE BELL" wrote in message
news:GFSEe.2657$vY2.91@trnddc09...
Greg,

My error - it works with some objects from the web, but not all.
Tried it on one of my copy/paste from an on-line account.

--
steveB

Remove "AYN" from email to respond
"Greg Wilson" wrote in message
...
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