I'm stuck!



I am trying to protect a worksheet in an excel workbook but I already have protected cells within the sheet.

I know how to protect the cells using locked cells but I want to protect 4 out of 5 sheets for being editable but when un locked leave the protected cells protected.

Example on attached spreadsheet:
I don't want the Title (A1), Ref No. (A3), Notes (B3) or the Ref numbers (A4:A8) to be editted on all the sheets
I also want to lock sheets2:5 so only sheet 1 can be editted, without changing the protected cells.

#All cells are unprotected in the example

Is there an easier way to do this than unprotecting all the cells and re-protecting everytime I want to open up another sheet?

Thanks for any help.

Attached Files

Protecting Sheets.xlsx (10.7 KB, 11 views)