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

[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

 

[pdberger]

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

 

[pdberger]

Yep. Is there something stronger? Or write some code when it opens? What
would your recommendation be?

 

[Bruce Sinclair]

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.

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

 

[Gord Dibben]

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

 

[Bruce Sinclair]

Yep. Is there something stronger? Or write some code when it opens? What
would your recommendation be?

Basically don't send confidential information. If it's in an XL
sheet/workbook, it is readable to anyone that cares enough.

 

[Bill Sharpe]

Basically don't send confidential information. If it's in an XL
sheet/workbook, it is readable to anyone that cares enough.

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