Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+courses - Protection
|
|
|
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+courses - Protection
Resolved · Low Priority · Version Standard
Reply Tue 29 Jan 2008, 16:47Delegate Roxanne said...
Roxanne has attended:
Excel Intermediate course
Protection
How would I protect a spreadsheet so that only I could delete but others can modify?
For upcoming training course dates see: Pricing & availability
RE: Protection
Hi Roxanne,
Thank you for your question.
To protect a worksheet:
- 1. Highlight all numbers
2. Select FORMAT menu -> Cells -> Protection
3. Uncheck box LOCKED -> Press OK
4. select TOOLS menu -> Protection -> Protect Sheet
5. Set a password & confirm the password
6. Press OK
Hope this is useful.
Regards,
Katie
|