TransferSpreadsheet to Pswd Protected Workbook

[SerenityNet]

Can you export (TransferSpreadsheet macro) to a password protected Excel workbook? If so then how? I haven't been able to find instructions on this (saying that I could or couldn't).

Thanks,
Andrew