How can Workbook Protection that has been applied to a workbook be removed? Open the file, enter the password, and then resave the workbook to remove the protection. Right-click the workbook and select Remove Protection from the menu list. Select the cells to unprotect, click the Home tab on the ribbon, and select Lock Cells in the Format menu. Click the Review tab on the ribbon and click Protect Workbook in the Changes group.