Unlock password Protected worksheet in Excel Open the workbook, Use Alt+F11 to enter the macro editor. Once in VBA double click the sheet you need to unlock from the menu listing on the left. Copy and Paste the following code