Security & password protection

[ogerriz]

I have a workbook with 20 worksheets which detail my 20 consultants
activities. What I want to do is to be able to email the individual
consultant the worksheet detailing their stats without having to save them
into 20 different workbooks for mailing to each consultant.

I was hoping for a solution where each worksheet will have a different
password that will allow viewing of that sheet only to the consultant who has
that password.

Is this possible?

 

[Roger Govier]

Hi

I wouldn't mail the whole workbook.
Whilst you can save each sheet with a different password, they are very easy
to crack with publicly available code.
If you don't want people to see the information - then don't send it.

Take a look at Ron de Bruin's site for lots of code on sending files by
email.
I think the one that would suit you is
http://www.rondebruin.nl/mail/folder1/mail5.htm