Protecting more than one worksheet in one workbook
 

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?

Protecting more than one worksheet in one workbook
 

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


--
Don Guillett
SalesAid Software

"RobP" wrote in message
...
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?