| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Check Box
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Check Box
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Check Box
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Check Box
Good call, Greg. I must not get files that use those much. :) Now I have to
go write another article! ******************* ~Anne Troy www.OfficeArticles.com "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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Check Box
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Check Box
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Check Box
In addition to Greg's method, you could try Edit--Go to--Special and
choose Objects, and hit OK. Then hit your Delete key. The difference is, this will select ANY and ALL objects, not just one or some. ******************* ~Anne Troy www.OfficeArticles.com "Shady Lady" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make a check form, and then have info go to a check register | Excel Worksheet Functions | |||
| Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
| Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
Hybrid Mode
