Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing check boxes (forms toolbar)
I STUPIDLY put columns of check boxes (from the forms toolbar) into my
spreadsheet. I couldn't get them to "stick" with the cells - everything would get skewed if I added a line etc., so now I want to remove them all. Is there any way to globally remove check boxes or other "objects" from Excel? Cell/Column deletes don't work. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing check boxes (forms toolbar)
Press F5 and select Special and select Objects. If this does not clear
everything then try the below --From the sheet hit the keys (Alt + F11) to launch VBE (Visual Basic Editor) --Hit (Ctrl + G) so that Immediate window will be enabled --Paste the below line including ? to the immediate window and enter (Make sure you press Enter after placing the cursor end of the line) ?Activesheet.drawingObjects.delete If this post helps click Yes --------------- Jacob Skaria "jvs" wrote: I STUPIDLY put columns of check boxes (from the forms toolbar) into my spreadsheet. I couldn't get them to "stick" with the cells - everything would get skewed if I added a line etc., so now I want to remove them all. Is there any way to globally remove check boxes or other "objects" from Excel? Cell/Column deletes don't work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check boxes from the forms tool bar | Excel Worksheet Functions | |||
check boxes in the forms tool bar | Excel Worksheet Functions | |||
Problem Deleting Check Boxes created from Forms Toolbar | Excel Discussion (Misc queries) | |||
Forms toolbar is grayed out - need a check box | Excel Discussion (Misc queries) | |||
Check box in Forms Toolbar | Excel Discussion (Misc queries) |