Macro to delete all rows if checkbox not checked

**hillmandj** · 03-15-2013, 05:51 PM

Hi!

I'm trying to create a spreadsheet that will automatically delete a row (and the checkbox itself) if a checkbox is not checked. It should shift all of the cells up, and delete all contents of the rows that are not checked. One issue is, the sheet would have to be able to be "reset" such that if someone clicks something by mistake and the macro is run, they could easily start from the beginning.

Is this possible? I'm using Excel 2010. Very new to programming macros, so don't really know anything. Please help!

-djh

**xlbiznes** · 03-15-2013, 05:57 PM

Hi,

Please post a sample workbook for others to understand and offer you a solution.

**hillmandj** · 03-15-2013, 06:02 PM

Sure, here is an example of the layout. I read a post on this forum about removing rows using checkboxes, so that code is in the "view code" section of worksheet1. It doesn't work properly though.