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.

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.