• Protecting formulas (Excel 2000/SP3)

    Author
    Topic
    #388992

    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?

    Viewing 0 reply threads
    Author
    Replies
    • #685412

      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.

      • #685444

        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?

        • #685445

          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.

    Viewing 0 reply threads
    Reply To: Protecting formulas (Excel 2000/SP3)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: