 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / July 2007Protection & visibility
Is there a way to protect worksheets within a work book so that they can't be seen without a password? On 7/24/07 3:36 PM, in article 1185305788.261835.39470@r34g2000hsd.googlegroups.com, "deeners" > 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.  SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom > On 7/24/07 3:36 PM, in article > 1185305788.261835.39470@r34g2000hsd.googlegroups.com, "deeners" [quoted text clipped - 3 lines] > > > 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. > In article <C2CBD21D.99499%...@nospam.com>, > [quoted text clipped - 4 lines] > > > Is there a way to protect worksheets within a work book so that they > > > can't be seen without a password? Thanks, I think I might put them in separate workbooks and password protect those. Would that be better? On 7/25/07 8:02 PM, in article 1185408164.747425.134400@d55g2000hsg.googlegroups.com, "deeners" >> In article <C2CBD21D.99499%...@nospam.com>, >> [quoted text clipped - 8 lines] > 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. SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom > On 7/25/07 8:02 PM, in article > 1185408164.747425.134...@d55g2000hsg.googlegroups.com, "deeners" [quoted text clipped - 21 lines] > Bob Greenblatt [MVP], Macintosh > bobgreenblattATmsnDOTcom Thanks, this helps a lot. I'll look into hosting it on a secure server location at work! You all are great!!!!! Thanks again! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.