Trick: Protect rows and columns without protecting sheet

Note: All Excel protection is relatively weak. It is useful to stop casual users but it is not for top secret information.

The problem with the Protect Sheets is that it does apply some limits and some users want everything to be open EXCEPT that they don’t want users to insert or delete rows and columns (this is a very common cause of spreadsheet errors or ‘templates’ corrupting). This is a trick to disable the insert/ delete option without protecting the sheet and no VBA.

To follow along go to 19.12

Lesson tags: vlookup
Back to: POPIA and GDPR Compliance- Built in Excel Tools that will help > Making protected Excel Spreadsheets easier to use