Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Password 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? -- Ash |
#2
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Password protect column
It sounds like you're talking about an Excel file. This NG is for Word.
-- Suzanne 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. "Ash" wrote in message ... 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? -- Ash |
#3
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Password protect column
Hi Ash,
Hiding a column in Excel doesn't prevent access - just display. Cheers "Ash" wrote in message ... 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? -- Ash |
#4
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Password protect column
If you are referring to Excel, you can hide the Column(s), then Password
Protect the Worksheet (ToolsProtectionProtect Sheet). Just make sure that you turn off the Locked Format property (FormatCellsProtection) 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" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password protect content editing vs. password protect open document ?? | Microsoft Word Help | |||
Password protect content editing vs. password protect open document ?? | New Users | |||
How do I password protect a "Word" Folder | Microsoft Word Help | |||
Is there any way to password protect a .rtf in Word? | Microsoft Word Help | |||
Password protect files | Microsoft Word Help |