| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
password protect column
How do you protect a column by a password once it is hidden. I have a spreadsheet that I have to share with others (send as attachment) and there is a piece of info in a column that has to be protected.Absolutely protected. -- Ash |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
password protect column
Ash
You can hide the column then go to ToolsProtectionProtect Worksheet but Excel's internal worksheet and workbook protection is very weak and passwords easily cracked. The general rule is........if you don't want someone to see data, do not include that data in the file you send. Gord Dibben MS Excel MVP On Fri, 26 May 2006 14:15:33 +0000, Ash wrote: How do you protect a column by a password once it is hidden. I have a spreadsheet that I have to share with others (send as attachment) and there is a piece of info in a column that has to be protected.Absolutely protected. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I password protect a hidden column in Excel? | Excel Worksheet Functions | |||
| hide a column in a worksheet and password protect | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Password Protect | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Linear Mode
