Worksheet protection

[ordnance1]

I have a workbook with 12 sheets. What I would like to do is protect all 12
with a password of "Popcorn", without having to select each sheet. Then I
would like to do the reverse of unprotecting them without having to select
them.

[colofnature]

You could add two routines to your workbook:

sub protect_all_sheets()
for each w in thisworkbook.worksheets
w.protect password:="Popcorn"
next
end sub

sub unprotect_all_sheets()
for each w in thisworkbook.worksheets
w.unprotect password:="Popcorn"
next
end sub



Col