Forum home » Delegate support and help forum » Microsoft Excel Training and help » Protecting Confidential Data
|
|
|
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. |
Protecting Confidential Data
Resolved · Low Priority · Version Standard
Reply Wed 20 Feb 2008, 16:42Delegate Vivienne said...
Vivienne has attended:
Powerpoint Introduction course
Protecting Confidential Data
How do you protect data in a cell and only allow authorised staff to view
For upcoming training course dates see: Pricing & availability
RE: Protecting Confidential Data
You can protect entire workbooks by going to tools>>protection>>protect workbooks. You can put a password in the sheet and only give the password to the staff you want. But you cannot protect a particular cell in the worksheet on its own and not let anyone see it. What you could try is hiding the column where the cell is. Then protect the worksheet with a password. Staff who knew the password would be able to take the protection off and then unhide the cells. Staff who didnt know the password cant take off the protection and then unhide the column.
|