Forum Discussion
Delete rows on a protected sheet
I am using Microsoft Excel version 2311 I created a document, entered data in it and protected it from the review tab. The options that I allowed for anyone who gets access to this worksheet (with...
As the error message indicates, you can only delete a row if all its cells are unlocked - otherwise it would defeat the protection.
The alternative is to create a macro that:
- Unprotects the sheet.
- Deletes the selected row(s).
- Protects the sheet again.
The macro can be assigned to a custom keyboard shortcut and/or a Quick Access Toolbar button.
Users would have to allow macros when they open the workbook.