Protecting more than one worksheet in one workbook

[Guest]

I have multiple worksheets in one workbook which I want to protect the cells
from anyone being able to view the formulas within them but still be able to
manipulate information within the spreadsheet. I also need to do this for
every single sheet and password protect. Is there an easy way to do this
with out going one by one and formatting the cells and then protecting the
sheet?

 

[Don Guillett]

a loop?
for each ws in worksheets
ws.doyourstuff
next ws