Thread: Hide Columns
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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