The following will help you Protect 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.
Then press F5 key to run the code, and enter the password that you want to apply for the 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.