hwaregister.blogg.se

Now, click on Protect Workbook > click on Always Open Read-Only.

You can protect your workbook by making it a Read-Only file. Read More: How to Protect Excel Sheet with Password (3 Quick Approaches) And only after giving the password, the file will open. 👇 You will see that anybody who opens the file now, will be asked to enter the password. You will see the following things afterward. Thus, every worksheet of your workbook will be encrypted with a password. Reenter your password inside the text box and click on the OK button. Now, the Confirm Password window will open.Enter your password in the text box and click on the OK button.

At this time, the Encrypt Document window will open.Now, click on Protect Workbook > click on Encrypt with Password. Subsequently, the Info window will open.At this time, click on the Info button from the expanded File tab.At first, click on the File tab from the ribbon.And, you can also edit your file later with the password. This will make your file protected from edits. You can protect your spreadsheet with a password. 6 Effective Ways to Protect a Worksheet in Excel 1.