Protect/Unprotect a group of worksheets

Posted by LP Yeoh on January 02, 2002 9:23 PM

Does anyone know of a macro which can protect and unprotect a group of worksheets using VBA?

Thanks

Posted by Jacob on January 02, 2002 10:13 PM

I use this alot

for x = 1 to sheets.count
sheets(x).unprotect("Password")
next x

HTH
Jacob