Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove an unwanted check box from an Excel spread sheet?
I copied some data from a website and without intending to brought a check
box with the data. I have tried to remove it but can't. Deleting cells or even the row the box is in doesn't do it. Years ago I had to create forms on a job and at the time knew how to create check boxes. But I can't find a Forms Creation tab in my present version of Excel (Microsoft Office 2003). Can anyone help me? I'd really like to get the check box out of my spread sheet. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove an unwanted check box from an Excel spread sheet?
Right click on the textbox (near the edge usually works best) and choose CUT
to remove it. Be aware that if any macros refer to the control, they may fail to function once it's gone. The toolbox for forms creation is available from View | Toolbars | Forms there is a similar one in there called ToolBox (same look, different functionality). Forms are now created and maintained within the Visual Basic Editor. "Brondero" wrote: I copied some data from a website and without intending to brought a check box with the data. I have tried to remove it but can't. Deleting cells or even the row the box is in doesn't do it. Years ago I had to create forms on a job and at the time knew how to create check boxes. But I can't find a Forms Creation tab in my present version of Excel (Microsoft Office 2003). Can anyone help me? I'd really like to get the check box out of my spread sheet. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove an unwanted check box from an Excel spread sheet?
try this macro Sub deletePic() Worksheets("Sheet1").Pictures.Delete End Sub |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove an unwanted check box from an Excel spread sheet?
Hi Brondero, If it's from the Control Toolbox then go View|Toolbars|Control Toolbox|Design mode(set square,ruler,pencil icon|right click check|Cut|deselect Design mode and close the Control Toolbox Ken Johnson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove an unwanted check box from an Excel spread sheet?
Hi Brondero, Oops, read "check" as "Checkbox" Ken Johnson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove an unwanted check box from an Excel spread sheet?
I have tested this code, with Controls inserted into the sheet, it works just fine |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove an unwanted check box from an Excel spread sheet?
damorrison wrote: I have tested this code, with Controls inserted into the sheet, it works just fine That's interesting, thanks. Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
How do I remove a check box from a worksheet in excel? | Excel Discussion (Misc queries) | |||
How do i update hyperlink in excel spread sheet automatically. | Excel Discussion (Misc queries) | |||
is there anyway to make it so the users of my excel spread sheet cant view the macro code w/o a password? | Excel Worksheet Functions | |||
How do I get rid of spare lines in an excel spread sheet? | Excel Worksheet Functions |