VBA to delete rows with protected columns

[lmmay]

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?

 

[Zot]

I'm not sure what was your problem since you use macro to unprotect and protect.

So, after unprotect just delete the row normally using either
Worksheets.Rows(Row#).Delete
Range(“Cell”).EntireRow.Delete

After that just protect again.

 

[lmmay]

I'm not sure what was your problem since you use macro to unprotect and protect.

So, after unprotect just delete the row normally using either
Worksheets.Rows(Row#).Delete
Range(“Cell”).EntireRow.Delete

After that just protect again.

Thanks. I want to unprotect a single sheet, perform the delete, then protect the sheet automatically. I don't want the user to have other access.

 

[Zot]

How is your approach?
1) Run macro and Protect Dialog box popped up. User key in password to unlock. Delete row manually. Run macro and Protect Dialog box popped up. User key in password to lock. Well this can be done manually also

2) Run macro and automatically unprotect. Delete row manually. Run macro to automatically protect. In this case. if any person know how to execute that macro will have access without knowing password.

 

[lmmay]

I will have the user send me the workbook if rows need deleting.