Protected Worksheets Query

[stephen.smith]

Hi Guys
I have a spreadsheet with 50 worksheets which are all protected and share the same password. Can I unprotect all sheets at one time or do I have to unprotect them all individually. Similarly can I Protect them all at once or must it be done individually.
Thanks
Stephen

 

[p45cal]

Unprotect them for the purposes of people editing the sheets or vba code changing the sheets?

They can be unprotected with code all at once and re-protected, but before I write anything, could you answer the above and is EVERY sheet in the workbook protected in the same way - ie. no unprotected sheet(s) at all.

 

[stephen.smith]

Yes they are all protected in the same way.
Thanks

 

[p45cal]

and "Unprotect them for the purposes of people editing the sheets or vba code changing the sheets?"