 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Long Documents / June 2006Password protect column
I have a spreadsheet that I have to email to others. The spreadsheet contains columns that I need/have to hide. Any one knows how I can password protect and hide a column so that the secretary who presents the final work does not have access to sensitive info?  SignatureAsh It sounds like you're talking about an Excel file. This NG is for Word. SignatureSuzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. > I have a spreadsheet that I have to email to others. The spreadsheet > contains columns that I need/have to hide. Any one knows how I can > password protect and hide a column so that the secretary who presents > the final work does not have access to sensitive info? Hi Ash, Hiding a column in Excel doesn't prevent access - just display. Cheers > I have a spreadsheet that I have to email to others. The spreadsheet > contains columns that I need/have to hide. Any one knows how I can > password protect and hide a column so that the secretary who presents > the final work does not have access to sensitive info? If you are referring to Excel, you can hide the Column(s), then Password Protect the Worksheet (Tools>Protection>Protect Sheet). Just make sure that you turn off the Locked Format property (Format>Cells>Protection) of any cells the other users may need to edit. HTH |:>) Bob Jones [MVP] Office:Mac On 5/25/06 10:41 PM, in article Ash.28eato@news.officefrustration.com, "Ash" > I have a spreadsheet that I have to email to others. The spreadsheet > contains columns that I need/have to hide. Any one knows how I can > password protect and hide a column so that the secretary who presents > the final work does not have access to sensitive info?
|
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
|
©2008 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.