I have used Ron De Bruins code to e-mail out a number of worksheets within
the same file - Thanks Ron, but what code do I use in order to protect this
E-Mail file from being opened (by an unauthorised user)

Thanks

Hi John

You can save the file with a password

Look in the VBA help for
SaveAs and see the this argument

Password Optional Variant. A case-sensitive string (no more than 15 characters)
that indicates the protection password to be given to the file.



--
Regards Ron de Bruin
http://www.rondebruin.nl


"John" wrote in message ...
I have used Ron De Bruins code to e-mail out a number of worksheets within
the same file - Thanks Ron, but what code do I use in order to protect this
E-Mail file from being opened (by an unauthorised user)

Thanks