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, FileSave AsToolsGeneral Options

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


HTH
"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

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

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

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

In article , ?B?cGRiZXJnZXI=?= wrote:
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. :)

Bruce Sinclair wrote:
In article , ?B?cGRiZXJnZXI=?= wrote:
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. :)

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