Protecting Worksheets in Excel 2010
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.
|