Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Soldotna, Alaska, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    protect a form (Excel 2000)

    How do I protect the background code but allow my numbers to be changed? If some one puts in a new number my A3*B3 disappears. I can not remember how to make it so the background code is not changed. see attached

  2. #2
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Soldotna, Alaska, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: protect a form (Excel 2000)

    I have tried using the protection and hidden formula but I want people to be able to change the values, just not whip out the code calculating it. Any ideas???

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

    Re: protect a form (Excel 2000)

    Select all of the cells that you want the user to be able to change. Then select Cells from the Format menu. Click on the Protection tab. Remove the check mark from next to Locked. Click OK. Now select Protection from the Tools menu and then select "Protect Sheet..." from the fly out menu. Enter a password if you want to have to use a password to unprotect the sheet and click OK. The user should now only be able to modify the cells that you unlocked.
    Legare Coleman

  4. #4
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Soldotna, Alaska, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: protect a form (Excel 2000)

    hum I tried it, but I can still whipe it out if I hit delete on C3. Take a look what do you think?

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

    Re: protect a form (Excel 2000)

    The worksheet does not appear to be protected (Tools Menu/Protection/Protect Worksheet). Since the workbook is shared with a password, I could not use the Protection menu command.
    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
  •