How can i password secure a workbook when i send it via e-mail

  • Thread starter Thread starter AN
  • Start date Start date
A

AN

I want to set up a password on a spreadsheet when i send it via e-mail the
recipient must enter a password before to able to view the spreadsheet.

For example: If i sent someone accidentally a spreadsheet with confidential
data he/she cannot open it unless i give him a password to open the
spreadsheet.

Thanks,

AN
 
AN --

When you save it, >File>Save As>Tools>General Options

That will get you to the password protect window for the file as a whole.


HTH
 
Yep. Is there something stronger? Or write some code when it opens? What
would your recommendation be?
 
AN --
Click to expand...
When you save it, >File>Save As>Tools>General Options
That will get you to the password protect window for the file as a whole.
Click to expand...

Note that XL password protection is weak. There are a number of password
removers out there, so you are only protecting yourself against the honest
:)
 
My recommendation is:

If you don't want someone to see the confidential data, remove it from the
workbook before emailing.


Gord Dibben MS Excel MVP
 
Yep. Is there something stronger? Or write some code when it opens? What
would your recommendation be?
Click to expand...

Basically don't send confidential information. If it's in an XL
sheet/workbook, it is readable to anyone that cares enough. :)
 
Bruce said:
Basically don't send confidential information. If it's in an XL
sheet/workbook, it is readable to anyone that cares enough. :)
Click to expand...
And protected VBA code can be read (but not executed) by opening the
Excel file in OpenOffice Calc. No need to hack the password.

Bill
 
Back
Top