Making protected Excel Spreadsheets easier to use

Trick: Protect rows and columns without protecting sheet

This is a preview lesson
Register or sign in to take this lesson.
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