Hi,

I have multiple worksheets in one workbook that I need to add protection to.
All the worksheets require the same protection with the same password. The
protection consists of 2 sets of "allow users to edit range" and overall
worksheet protection.

I have 2 questions:

1. Is there a way to copy the protection from one worksheet to another, or
create the protection to all worksheets via a macro, so I don't have to
protect each worksheet separately?

2. Is there way to unprotect all the worksheets with same password at one
time via a macro or other mechanism?

Thanks,

Johnell