If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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?
|
#2
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mozilla Firefox problem Please Hejp | shen923 | Publisher | 8 | May 16th, 2006 08:16 AM |
Password protect content editing vs. password protect open document ?? | Camille Petersen | General Discussions | 6 | May 3rd, 2006 01:25 PM |
hide a column in a worksheet and password protect | eoreality | General Discussion | 1 | February 8th, 2006 02:42 AM |
How can I password protect a hidden column in Excel? | Ira.Stoller | Worksheet Functions | 8 | December 13th, 2005 01:50 PM |
Protect Workbook vs Worksheet?? | Dan B | Worksheet Functions | 3 | November 7th, 2005 09:02 PM |