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

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

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

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?