how do i encrypt an excel workbook/worksheet report? in Excel Worksheet Functions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
Russell 4/13/2005 4:52 AM PST
  Question
  I want to encrypt a worksheet before sending it to a mail recipient for them
to be able to open it if they know the password. Is this the same as
password protection? What are the procedures I need to follow to do it?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
º¼ÖÝÈË 4/13/2005 5:09 AM PST
  Answer
  tool--protect--protect worksheet or file--save as--option--password
"Russell" <Russell@discussions.microsoft.com> дÈëÓʼþ
news:72C7F4C7-C360-41BD-AB9E-0669CDBD1422@microsoft.com...
> I want to encrypt a worksheet before sending it to a mail recipient for
them
> to be able to open it if they know the password. Is this the same as
> password protection? What are the procedures I need to follow to do it?


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Gord Dibben 4/13/2005 1:15 PM PST
   
  Russell

Note: there are 3 types of Protection which can all be passworded.

1. WorkSheet protection from Tools>Protection

2. WorkBook protection from Tools>Protection

3. File protection from File>Save As>Tools>General Options(XL2002)

Pick the one you want.

You don't need to Encrypt as as I can envision, but to do so would require
Tools>Options>Security and Advanced.


Gord Dibben Excel MVP

On Wed, 13 Apr 2005 04:53:03 -0700, "Russell"
<Russell@discussions.microsoft.com> wrote:

>I want to encrypt a worksheet before sending it to a mail recipient for them
>to be able to open it if they know the password. Is this the same as
>password protection? What are the procedures I need to follow to do it?

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies