Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultant - Security
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel consultant - Security
Resolved · Low Priority · Version Standard
Reply Tue 25 Sep 2007, 17:04Delegate Elaine said...
Elaine has attended:
Excel Intermediate course
Excel Advanced course
Security
How can I check that my formulas are protected ?
For upcoming training course dates see: Pricing & availability
Reply Tue 2 Oct 2007, 16:38Delegate Paul said...
RE: Security
Hi Elaine
first of all, check your whole worksheet is protected by hitting tools > Protection and depending on whether it says 'protect sheet' or 'unprotect sheet' you'll know
then, click on the cell that has the formula you want protecting and click format > cells.
click the protection tab at the top of the box you can now see and ensure 'protected' is checked.
that cell is protected, so you can go out of that box and now try typing something into that cell, Excel won't allow it
Hope this helps
Paul
|