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