Forum home » Delegate support and help forum » Microsoft Excel Training and help » Workbook 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. |
Workbook protection
Resolved · Low Priority · Version 2010
Reply Fri 16 Dec 2011, 17:18Delegate Hatice said...
Hatice has attended:
No courses
Workbook protection
Hi,
Is it possible to protect my workbook data from being hijacked by other people. I only want certain cells to be overtyped but at the same time I would like to keep my formulated cells to be locked?
Thank you
Hatice
For upcoming training course dates see: Pricing & availability
RE: Workbook protection
Hi Hatice,
Thank you for your question and welcome to the forum.
Select the cells that need to be overwritten and right click over one of the selected cells. Choose Format Cells and then select the Protection tab. Finally, untick the Locked checkbox.
Now you are ready to protect the sheet with a password. Go to the Review Tab on the ribbon and click Protect Sheet. Type a password in and re-enter to confirm.
All the cells on that sheet will be locked apart from the ones you unlocked.
I hopw this answers your question.
Regards
Simon
Wed 28 Dec 2011: Automatically marked as resolved.
|