Protection & visibility

[deeners]

Is there a way to protect worksheets within a work book so that they
can't be seen without a password?

 

[Bob Greenblatt]

Is there a way to protect worksheets within a work book so that they
can't be seen without a password?

You could hide them, and then protect the workbook structure.

 

[JE McGimpsey]

You could hide them, and then protect the workbook structure.

Just note that this shouldn't be used for information that must remain
confidential. Anyone who can find these newsgroups can find techniques
for bypassing workbook protection.

 

[deeners]

Thanks,
I think I might put them in separate workbooks and password protect
those. Would that be better?

 

[Bob Greenblatt]

Thanks,
I think I might put them in separate workbooks and password protect
those. Would that be better?

I don't know about better, depends on what you are trying to achieve. As
J.E. Pointed out these methods are not particularly secure, and easy to
"crack." If you are just trying to remove intermediate data from "friendly"
users, either will work fine.

 

[deeners]

I don't know about better, depends on what you are trying to achieve. As
J.E. Pointed out these methods are not particularly secure, and easy to
"crack." If you are just trying to remove intermediate data from "friendly"
users, either will work fine.

Thanks, this helps a lot. I'll look into hosting it on a secure server
location at work!
You all are great!!!!!
Thanks again!