Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Columns
Friends,
I wish to hide columns and wouldnt want the recipient of the Excel file to Unhide it. Is this possible? Regards HAJO |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Columns
Hi,
Use Tools Protection ... HTH Cheers Carim |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Columns
You can hide the column and protect the worksheet. But the data in those
columns isn't secure. Worksheet protection is easily broken and the values can still obtained other ways. So if the data is sensitive, don't trust excel's protection. hajo wrote: Friends, I wish to hide columns and wouldnt want the recipient of the Excel file to Unhide it. Is this possible? Regards HAJO -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Columns
You can hide the columns and protect the workbook structure but as far as
keeping out prying eyes............ That would depend upon the level of expertise of the recipient. If you hid the columns and protected the workbook with a password under ToolsProtection it would take a user who can use the internet to find password-cracking applications not much more than a few seconds to strip the protection and unhide the columns. The general rule is "if you don't want them to see it, don't include it" Gord Dibben MS Excel MVP On 2 Sep 2006 08:59:55 -0700, "hajo" wrote: Friends, I wish to hide columns and wouldnt want the recipient of the Excel file to Unhide it. Is this possible? Regards HAJO |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide Columns
The only sure way is to *delete* the columns.
If these columns contain relevant data values and/or formulas, copy the file, Paste Special, Values. This way, everything is properly displayed with no chance of revealing any proprietary information. However, there is now no chance for this file to perform any computations. If the recipient is supposed to *use* this file for calculating, then you're out of luck as far as *absolutely* protecting your confidential information. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "hajo" wrote in message ups.com... Friends, I wish to hide columns and wouldnt want the recipient of the Excel file to Unhide it. Is this possible? Regards HAJO |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Columns Using Numbered References | Excel Discussion (Misc queries) | |||
macro to hide columns | Excel Worksheet Functions | |||
how can hide and show columns using macro? | Excel Worksheet Functions | |||
Getting Excel error when trying to hide columns. Why? | Excel Discussion (Misc queries) | |||
Hide Cell Content if no data in previous columns | Excel Discussion (Misc queries) |