1. Go to Tools > Macros > Visual Basic Editor.
2. Right-click on your workbook and select Insert > Module, and paste the following code in the Module Window.
3. Then press F5 key to run the code, and enter the password that you have applied for the protected sheets. (the protected sheets must have the same password)
4. Click OK, and the protected sheets have been protected/unprotected at once.