VBA to pwd protect a spreadsheet then email it?
Is there a way in VBA to email a spreadsheet as password protected? This is what I want to do:
1. Open a new spreadsheet and populate it.
2. Email it with Microsoft Outlook (spreadsheet has to be pwd protected).
Then is there a way to delete the spreadsheet after it is sent? For security reasons, we don't want a saved version to be hanging around. This entire process will be automated, and nobody will be monitoring it daily to delete the spreadsheets.