Free Ways to Unprotect an Excel Sheet without Password
So you are prompted with the warning message each time you attempt to modify an Excel cell?
It means the Excel sheet is protected and you need to unprotect it by click on the Unprotect Sheet button in the Changes group under the Review tab.
When a password is required to unprotect sheet but you don’t know the password or forgot it, what can you do in such a situation?
Take it easy! There are two free ways you can unprotect Excel sheet without password.
How to unprotect Excel sheet without password for free
Free Way 1: Unprotect Excel sheet without password using VBA codes
You may know little about VBA codes. But never mind. Here you just need to type several lines of VBA codes to unprotect your Excel sheet.
Step 1: Open the Excel file. Press Alt + F11 to open Microsoft Visual Basic for Applications window.
Tips: If you are asked for a password to open the Excel file, type in the right password. If you don’t know (or remember) the password, see how to remove or recover Excel password.
Step 2: Double click on the sheet you need to unprotect. Then type the codes in the blank field as the picture shown as below. Be careful and do not miss anyone character or word.