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

On Tue, 1 Apr 2008 17:27:02 -0700, pdberger
wrote:

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



"Bruce Sinclair" wrote:

In article , ?B?cGRiZXJnZXI=?= wrote:
AN --

When you save it, FileSave AsToolsGeneral 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
:)


"AN" wrote:

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