LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide Columns Using Numbered References [email protected] Excel Discussion (Misc queries) 1 January 11th 06 07:09 PM
macro to hide columns Shooter Excel Worksheet Functions 2 September 27th 05 09:04 PM
how can hide and show columns using macro? Hoshyar Excel Worksheet Functions 4 September 2nd 05 03:45 PM
Getting Excel error when trying to hide columns. Why? MClark Excel Discussion (Misc queries) 1 April 28th 05 11:28 PM
Hide Cell Content if no data in previous columns Sherry Excel Discussion (Misc queries) 4 February 21st 05 07:27 PM


All times are GMT +1. The time now is 09:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"