Password on an E-Mail File via VB

  • Thread starter Thread starter John
  • Start date Start date
J

John

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

E-mailing from Excel Q 13
Send Mail Q 12
attaching specific files to e-mails 1
How to I activate Excel 1
How to receive e-mail using Excel VBA 4
E-Mailing from Excel 4
Sending mail from Excel with CDO by Ron de Bruin 4
E-Mailing Execl via Outlook Express 1

Back
Top