Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problem Deleting Check Boxes created from Forms Toolbar
I managed to overlay about 200 checkboxes in one cell (long story). I have
too much invested in this worksheet to just start over. Deleting the row doesn't help, they just move somewhere else. Other than continuing to delete them one by one, does anyone have a suggestion for clearing this cell? Thanks in advance. |
#2
|
|||
|
|||
Try 'Edit' om the Toolbars, 'Go to' 'Special' check 'Objects' . Right
click one of the highlighted objects and Cut and it will Cut them all, clear the clipboard and that should be that, Regards, Alan. "Suzan" wrote in message ... I managed to overlay about 200 checkboxes in one cell (long story). I have too much invested in this worksheet to just start over. Deleting the row doesn't help, they just move somewhere else. Other than continuing to delete them one by one, does anyone have a suggestion for clearing this cell? Thanks in advance. |
#3
|
|||
|
|||
I thought of that but the problem is that I have other check boxes that I
don't want to remove. If I can't find another way, this will be the way to go and I will just redo the other ones. Thanks "Alan" wrote: Try 'Edit' om the Toolbars, 'Go to' 'Special' check 'Objects' . Right click one of the highlighted objects and Cut and it will Cut them all, clear the clipboard and that should be that, Regards, Alan. "Suzan" wrote in message ... I managed to overlay about 200 checkboxes in one cell (long story). I have too much invested in this worksheet to just start over. Deleting the row doesn't help, they just move somewhere else. Other than continuing to delete them one by one, does anyone have a suggestion for clearing this cell? Thanks in advance. |
#4
|
|||
|
|||
I dont really think there is another way, but hopefully someone on here will
prove me wrong, Good Luck, Regards, Alan. "Suzan" wrote in message ... I thought of that but the problem is that I have other check boxes that I don't want to remove. If I can't find another way, this will be the way to go and I will just redo the other ones. Thanks "Alan" wrote: Try 'Edit' om the Toolbars, 'Go to' 'Special' check 'Objects' . Right click one of the highlighted objects and Cut and it will Cut them all, clear the clipboard and that should be that, Regards, Alan. "Suzan" wrote in message ... I managed to overlay about 200 checkboxes in one cell (long story). I have too much invested in this worksheet to just start over. Deleting the row doesn't help, they just move somewhere else. Other than continuing to delete them one by one, does anyone have a suggestion for clearing this cell? Thanks in advance. |
#5
|
|||
|
|||
I did it the way you suggested and then replaced the other ones. Thanks for
your help. This site is the greatest! /s "Alan" wrote: I dont really think there is another way, but hopefully someone on here will prove me wrong, Good Luck, Regards, Alan. "Suzan" wrote in message ... I thought of that but the problem is that I have other check boxes that I don't want to remove. If I can't find another way, this will be the way to go and I will just redo the other ones. Thanks "Alan" wrote: Try 'Edit' om the Toolbars, 'Go to' 'Special' check 'Objects' . Right click one of the highlighted objects and Cut and it will Cut them all, clear the clipboard and that should be that, Regards, Alan. "Suzan" wrote in message ... I managed to overlay about 200 checkboxes in one cell (long story). I have too much invested in this worksheet to just start over. Deleting the row doesn't help, they just move somewhere else. Other than continuing to delete them one by one, does anyone have a suggestion for clearing this cell? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do you have instructions for making check boxes? | Excel Worksheet Functions | |||
check off, look up forms - VERY confused | Excel Discussion (Misc queries) | |||
Check boxes to show/hide Tabs | Excel Worksheet Functions | |||
Creating Formula using check boxes | Excel Discussion (Misc queries) | |||
how to incert multiple check boxes in excel | Excel Worksheet Functions |