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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

allow a user to edit ranges in a protected worksheet 3
Copying Worksheets 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How can I merge unprotected cells in a protected worksheet? 1
How do I lock the formatting of my worksheet but still add text? 2
How do you insert & delete rows in a protected worksheet? 1
how to link format of cells 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top