Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How can I save Excel protected sheet?

user-image
Question ajoutée par Hussein Abdel Mageed , Senior Accounts Payable , Nile City Investments
Date de publication: 2017/08/10
Shafeequr Rahman
par 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