MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Protect/Unprotect a group of worksheets


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

Hi

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

Hi

I use this alot

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


HTH
Jacob