Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    May 2003
    Location
    Mid-Cheshire, England
    Posts
    275
    Thanks
    1
    Thanked 3 Times in 3 Posts

    Protecting formulas (Excel 2000/SP3)

    Using a work sheet I have created a `form' that for multiple use I have saved as a template (.xlt). Initial use by an inexperienced operator shows that it is all too easy to delete the formulas from the cells where they are stored. Perhaps I should have created a Form but I am not familiar with them. I intend to look into this topic both in Word & Excel.

    In the meantime is there a way I can readily protect the formulas from accidental deletion?

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

    Re: Protecting formulas (Excel 2000/SP3)

    This is a two-step process.

    First, select the cells that the users are allowed to modify. Then select Format | Cells..., and uncheck the Locked check box in the Protection tab.

    Second, select Tools | Protection | Protect Sheet... If you only want to prevent uses from accidentally overwriting a formula, click OK. For slightly more protection, enter a password, then click OK (you will be asked to type it again). Later on, the menu item will read Tools | Protection | Unprotect sheet. If you set a password, you must enter it in order to unprotect the sheet.

  3. #3
    3 Star Lounger
    Join Date
    May 2003
    Location
    Mid-Cheshire, England
    Posts
    275
    Thanks
    1
    Thanked 3 Times in 3 Posts

    Re: Protecting formulas (Excel 2000/SP3)

    Thank you Hans. Successful to a point but I am up against a problem that I can't deal with.

    There are two combo boxes with drop down lists & several calendar controls all from the Control Toolbox. I cannot select the combo boxes to allow user modification & the calendar controls don't work unlocked with the sheet protected.

    This is messy - can you help me further please?

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

    Re: Protecting formulas (Excel 2000/SP3)

    Dropdown lists and calendar controls have a LinkedCell property that you set in the Properties window. The linked cells should not be locked.

    Unprotect the sheet.
    Select the linked cell of each of the dropdown lists and calendar controls, and unlock them (Format | Cells...)
    Protect the sheet again.

Posting Permissions

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