Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    May 2006
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Protect Math In A Single Cell (2000)

    Situation: I would like to protect the math calculation/formula in a single cell in a worksheet. Any ideas? I would also like to make the file where the worksheet is located a "read only" file.
    Any ideas?
    Thanks.

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

    Re: Protect Math In A Single Cell (2000)

    Welcome to Woody's Lounge!

    Protecting a worksheet is a two-step process in Excel. By default, all cells in a worksheet are locked, but this only becomes effective when the worksheet is protected.
    The first step is to unlock all cells the user should be able to modify:
    - Select the modifiable cells.
    - Select Format | Cells...
    - Activate the Protection tab.
    - Clear the "Locked" check box.
    - Click OK.
    The second step is to protect the worksheet:
    - Select Tools | Protection | Protect Sheet...
    - If desired, set a password.
    - Click OK.

    You can make a workbook (.xls file) read-only in Windows Explorer, but that doesn't mean much. Any user with full permissions in the folder can still delete the workbook. But changes cannot be saved - the user can use File | Save As... to save the workbook under another name.
    You can set a password needed for opening and/or for saving the password: select File | Save As..., and in the Save dialog, select Tools | General Options...

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Protect Math In A Single Cell (2000)

    Hans,
    Any way to protect just one cell of a worksheet?
    Thanks

  4. #4
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Protect Math In A Single Cell (2000)

    Try following Hans' instructions by selecting all cells, and de-selecting 'Locked'. Then select the one cell you want to protect and lock it.

  5. #5
    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 Math In A Single Cell (2000)

    The answer Hans gave can be applied to just one cell: unprotect all the other cells and then protect the workbook.

    Alternative ideas is to put the cell you want protected into another worksheet (you can even make it "Very Hidden" or even use a named formula instead of a cell.

    Steve

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Protect Math In A Single Cell (2000)

    Thanks Leif and Hans...

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Protect Math In A Single Cell (2000)

    Thanks, Hans; works perfectly!

Posting Permissions

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