Protecting multiple sheets:How can I protect/unprotect all 31 at once?

Originally Posted by sls-sls

I have a workbook with 31 sheets in it. How can I protect/unprotect all 31 at once? It takes too long to do them one at a time and they will all have the same password anyway. Thank You.

Hi,

setup a macro something like

Please Login or Register  to view this content.

hth
---