The following will help you Unprotect an entire workbook in one go using VBA. It is best if you know how to use or run VBA code to use this. If you don’t know how to use VBA code feel free to contact us.
Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window. Or alternatively choose it from the Ribbon in the Developer option.
Click Insert > Module, and paste the following code in the Module Window.
Sub unprotect_all_worksheets()
On Error GoTo Excelsupport
unpass = InputBox("Please enter the password:")
For Each Worksheet In ActiveWorkbook.Worksheets
Worksheet.Unprotect Password:=unpass
Next
Exit Sub
Excelsupport: MsgBox "There is an error with what you have entered - check password spelling or capslock."
End Sub
Then press F5 key to run the code, and enter the password that you have applied for the protected sheets or alternatively insert a button or shape and assign the macro to it by right clicking on the button and selecting Assign Macro and then choosing the above.
Below is a short video on how to do this.