Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Aug 2004
    Posts
    47
    Thanks
    2
    Thanked 0 Times in 0 Posts

    uneditable cells (excel 2000)

    Is there any way that I can make the cells read only? For example, I just finish working on a spreadsheet, which contains some important formula and data. Someone else will looked at the sheet and add some more info. However, I don

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: uneditable cells (excel 2000)

    The quickest way to do this is to Protect the sheet!
    Choose TOOLS | PROTECTION | PROTECT SHEET, type in a password and choose OK!
    Regards,
    Rudi

  3. #3
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: uneditable cells (excel 2000)

    If you want to allow other users to add something in other cells, you will need to select those "other" cells and unlock them BEFORE protecting the worksheet.

    But, keep in mind this will only keep the average user from removing your protection. Most people who view these newsgroups or forums will be able to remove your protection within a matter of seconds.

    Excel spreadsheet security is really mostly a joke.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: uneditable cells (excel 2000)

    1- Select all of the cells that you want other people to be able to change.

    2- Select Cells from the Format menu, and then click on the Protection tab in the resulting dialog box.

    3- Click on the check mark next to Locked to remove the check mark, then click on OK.

    4- Click on Protection on the Tools menu, then click on Protect Sheet on the fly out menu.

    5- Type a password in the dialog box to keep the other user from being able to unprotect the sheet without the password (Excell passwords are not hard to break if you know how).

    6- Click on OK

    You should now only be able to modify the cells that you unlocked.
    Legare Coleman

Posting Permissions

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