Date:         Wed, 19 Jan 2005 10:56:24 -0700
Reply-To:     Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Subject:      Re: How to protect excel worksheet using SAS
Comments: To: tshunket.chia@CITIGROUP.COM
Content-Type: text/plain; charset=us-ascii

You won't be able to obtain data privacy with a protected worksheet.
Google "excel password" to see how easy it is to break Excel password
protection.

<http://www.lostpassword.com/excel.htm> says 'Excel Key does not work
with documents created with restricted permission using the "Information
Rights Service for Microsoft Office".'  Sounds like you'll have to go to
Excel 2003 to get what you want.



--
JackHamilton@FirstHealth.com
Manager, Technical Development
Metrics Department, First Health
West Sacramento, California USA

Coelum, non animum mutant, qui trans mare currunt.


>>> "T.K. Chia" <tshunket.chia@CITIGROUP.COM> 01/18/2005 7:46 PM >>>
SAS guru out there,

I'm suppose to export data from SAS dataset(SAS8.2) to Excel
(Excel2000).
Due to data privacy, the excel worksheet must be protected to avoid
data
manipulation (protect worksheet function in Excel).  How can I use SAS
program to acheive this?

Thanks in advance.

T.K.


"MMS <firsthealth.com>" made the following annotations.
------------------------------------------------------------------------------
This message, including any attachments, is intended solely for the use
of the named recipient(s) and may contain confidential and/or
privileged information.  Any unauthorized review, use, disclosure or
distribution of this communication(s) is expressly prohibited.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy any and all copies of the original message.
Thank you.
 =============================================================================