Protect Sheet on multiple sheets

I need to protect about 100 worksheets in one workbook with the same password. Each sheet would be (initially) identical to every other worksheet with some cells locked and some cells unlocked (the same for each sheet).

When I select muiltiple worksheets (to operate on all of them at the same time) I can lock and unlock the desired cells, but I cannot set a password on the worksheets. I can only apply a password to a sheet one at a time, which takes too long for entering about 100 passwords twice.

Is there any quick way to accomplish this?

Bump no response

Here is a very quick way via a macro.

Hit ALT + F11 to enter the VB editor.
From the menu, select Insert > Module.
Copy the following code to the window:

Please Login or Register  to view this content.

Be sure to change the password in the code above.

Exit out of the VBE to return to Excel, then to run the macro, go to Tools > Macro > Macros, then select the macro to run.

HTH

Jason

In order to not have the password listed in the macro(s) can the macro prompt for the password?

Thanks!