
Step 1: Go to the “File” option, which is the first in the ribbon.
Follow the below steps to protect the workbook at the workbook level. Using this method, we restrict the user from peeping into the workbook. In this method, we can preserve the workbook at the workbook level, which will prevent a user from opening it when you are not around with your computer. In the previous step, we have seen how to protect the workbook at the file level.
Click on “OK.” In the next window, we need to re-enter the same password we entered in the previous step.Ĭlick on “OK.” It will protect the workbook at the file level.Įxcel Workbook Protection at Workbook Level. In the below “Protect Structure and Windows” window, enter the password as per the choice. Now, we can see the below option, which asks for a password to be entered to protect. Then, go to the “Review” tab and click on the “PROTECT WORKBOOK” option.
First, we must open the Excel workbook that we need to protect.