Welcome to the third in our three-part series on worksheet protection (if you sat through the first two, you deserve this). Let’s say that you WANT other users to change the NUMBERS in a worksheet, but NOT the formulas, so that they can see how your model works with their numbers. No problem. All you have to do is “unlock” the number cells before you protect the worksheet, as follows:
- 1. Select the cells you WANT people to be able to edit. (DO NOT SELECT CELLS CONTAINING FORMULAS!)
These institutions should be forced to reduced interest rates on personal loans and business loans, and the insurance companies and oil companies should be forced to viagra free pills reduce their structure by 25%. The male impotence can cause divorce, breakup brand cialis canada and problems in relationships. It is a natural way to enhance one’s cardiovascular and sexual devensec.com purchase cheap viagra health. Bluze capsules purchase viagra in canada is the best answer to erectile dysfunction.
- 2. Right-click the selection and choose Format Cells from the shortcut menu.
- 3. Click the Protection tab.
- 4. Turn off the option called Locked. (Cells are locked by default; that’s why you don’t have to lock the formula cells.)
- 5. Click OK.
- 6. Choose Tools + Protection + Protect Sheet.
- 7. Make sure Contents is selected.
- 8. In the Password box, type a password (you need a password because when someone tries to edit protected cells, Excel displays a message explaining how to turn off protection). REMEMBER OR JOT DOWN THE PASSWORD; if you forget it, you’re never getting into this sheet again.
- 9. Click OK; in the box that appears, retype the password, and click OK.
From now on, anyone can change your numbers, but only those who know the password can edit your formulas. So keep that password to yourself.