#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
I may be missing somthing but if you lock cells A1 A3 and A4:A8 and all other cells are unlocked and then sheet is password protected you can edit all cells except A1 A3 & A4:A8
I changed your sheets to show this >>> to unprotect sheet just go unprotect [ no password required ] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Merge from 2 excel worksheets | apolloman | Mail Merge | 2 | 06-02-2011 04:16 AM |
Help with protecting folders?? | charger shop | Outlook | 3 | 04-06-2011 02:52 PM |
Protecting word documents | elgell | Word | 1 | 03-25-2011 02:49 PM |
Relinking excel worksheets | iffy | Excel | 2 | 01-07-2011 01:53 PM |
Protecting your logo in Word | TimD | Word | 5 | 04-29-2010 07:10 AM |