The first step is to unlock cells where you want to allow users to make changes to the data or formula:
Open the Excel workbook with password protection.To remove a password to protect workbook structure: Removing a password to protect workbook structure Users will not be able to change, delete, move or unhide worksheet tabs.
Be sure to keep your password in a safe place.īelow is the Protect Structure and Windows dialog box: