If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Check boxes - when one box is checked, I want a 2nd box to auto ch | Russell-stanely | General Discussion | 2 | July 1st, 2005 08:52 PM |
Word Problem w/Auto Text and Spell Check and Crashing | HW | General Discussion | 1 | January 12th, 2005 04:59 AM |
Spell Check language change problem | Jackie | General Discussion | 3 | June 10th, 2004 10:25 AM |
Help with Inserting check boxes on a already created document | Kasaia | General Discussion | 2 | May 14th, 2004 08:19 PM |
Check boxes not working through Hyperlink | Jim | Worksheet Functions | 0 | January 21st, 2004 05:16 PM |