Encrypt 2007 xlsx file using VBA
 

Is it possible to Encrypt an xlsx file using VBA?
(I'm creating 50 or 60 files on the fly and attaching them to emails -
manually adding passwords will be painful!)

Any help much appreciated.
Jason.

Encrypt 2007 xlsx file using VBA
 

The third argument of the workbook SaveAs method is Password, so you can use
that to encrypt workbooks. See help for SaveAs.

--
Jim
"WhytheQ" wrote in message
...
| Is it possible to Encrypt an xlsx file using VBA?
| (I'm creating 50 or 60 files on the fly and attaching them to emails -
| manually adding passwords will be painful!)
|
| Any help much appreciated.
| Jason.

Encrypt 2007 xlsx file using VBA
 

Thanks Jim.

Jason.


On 8 Sep, 12:17, "Jim Rech" wrote:
The third argument of the workbook SaveAs method is Password, so you can use
that to encrypt workbooks. *See help for SaveAs.

--
Jim"WhytheQ" wrote in message

...
| Is it possible to Encrypt an xlsx file using VBA?
| (I'm creating 50 or 60 files on the fly and attaching them to emails -
| manually adding passwords will be painful!)
|
| Any help much appreciated.
| Jason.