Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How can I save Excel protected sheet?

user-image
Question added by Hussein Abdel Mageed , Fixed Assets Controller , Nile City Investments
Date Posted: 2017/08/10
Shafeequr Rahman
by Shafeequr Rahman , Electrical Engineer , SAUDI ARABIAN INDUSTRIAL AND TRADING CO.

To protect workbook Structure, click File > Info > Protect Workbook > Protect Workbook Structure, and select options to prevent users from modifying data.

To Encrypt with password, click File > Info > Protect Workbook > Encrypt with Password, The Encrypt Document dialog box appears. In the Password box, type a password, and then type it again when prompted.

To protect Current Sheet, click File > Info > Protect Workbook > Protect Current Sheet, and you can select password protection and allow or disallow users to modify data.

To remove password encryption from the file, open the workbook and enter the password in the Password box. Then click File > Info > Protect Workbook > Encrypt with Password. Delete the contents of the Password box, click OK, and then save the file again.

To remove password protection from the workbook structure, click File > Protect Workbook Structure, and then type the password in the Unprotected Workbook dialog box.

hope this helped.

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.