Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Protect selected cells (2003)

    We're working with a spreadsheet that has formulas in certain cells. Those same cells also have conditional formatting, such that if the value that displays is greater than or less than zero, the results display in either red or green. The user wants to protect the cells that have the formulas, but only those cells. He wants to allow other users to modify the data in cells that factor into the formulas in the protected cells. It appears that to protect the cells that hold the formulas, we have to apply protection to the entire sheet. When we do that, we can't change the data in the unprotected cells. I'm a real novice at this kind of thing. What's the solution, please.Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Protect selected cells (2003)

    Protection is a two-step process in Excel
    1) Unlock the cells that the user should be able to edit.
    2) Protect the sheet.

    If you want to protect only a few cells, do it like this:
    - Click the button to the left of the column headings and above the row headings to select all cells.
    - Select Format | Cells...
    - Activate the Protection tab.
    - Clear the Locked check box.
    - Click OK.
    - Select the cells that you want to protect (those with formulas).
    - Select Format | Cells...
    - Activate the Protection tab.
    - Tick the Locked check box.
    - Click OK.

    - Select Tools | Protection | Protect Sheet...
    - Specify what you want the user to be able to do (minimum: select unlocked cells).
    - If you wish, specify a password that will be asked to unprotect the sheet.
    - Click OK. (If you specified a password, you'll be asked to confirm it)

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Protect selected cells (2003)

    By default all cells are protected. Thus you must UNLOCK the cells you wish to allow editing in, then add the protection to the sheet. If you don't explicilty unlock the cell, excel uses the default which is locked.

    Steve

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Protect selected cells (2003)

    Thanks, Hans and Steve, for the speedy replies!

    I think we've lured another MS-Office user into Woody's Lounge!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •