Removing check boxes (forms toolbar)

[jvs]

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.

 

[Simon Lloyd]

This will work on sheet1 or did you want all sheets

Code
-------------------
For Each Shape In Sheets("Sheet1").Shape
Shape.Delet
Next Shap
-------------------

I STUPIDLY put columns of check boxes (from the forms toolbar) into m
spreadsheet. I couldn't get them to "stick" with the cells - everythin
would get skewed if I added a line etc., so now I want to remove the
all

Is there any way to globally remove check boxes or other "objects" fro
Excel? Cell/Column deletes don't work

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[Jacob Skaria]

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