- Jun 6, 2014
I have a sheet in a workbook with protected columns. I would like to enable the user to delete 1 or more rows. I need to unprotect the sheet, select rows to be deleted then protect the sheet automatically when the rows are deleted. I use a macro to unprotect the workbook and a macro to protect. How can I do the row deletion?