Restricting Access to Parts of worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet in Excel 2003. I have 7 users of this sheet and only want
them to be able to update cells relevant to them. I tried Protection/Allow
Users to edit etc. but any help much appreciated.
 
First you need to select all the cells in the workbook, and format cells,
protection, and uncheck the box marked "locked".
Then select the cells you want locked, and format cells, protection, locked.
Then you can protect your workbook.

Steve
 
Back
Top