I am currently working on a macro excel file and its working fine, it is automatically sending email with PDF attachment as per my previous requirement, however I wanted to make the PDF generated file a password protected. How can i do this?
I am currently working on a macro excel file and its working fine, it is automatically sending email with PDF attachment as per my previous requirement, however I wanted to make the PDF generated file a password protected. How can i do this?
Last edited by julsq; 07-20-2023 at 05:15 AM.
Welcome to the forum.
Is your Excel version 365? Please add this information to your profile.
Click on Edit to open your post, paste your VBA code, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi, Thank you for welcoming me.
Yes, Microsoft 365 - Excel Version 2307. I have added in my profile.
Will you be able to help me to password protect the PDF file generated from MACRO/VBA?
I won't, but whoever does will need to see your VBA code - please provide it as indicated in my previous post, or you could attach a workbook.
I don't think this ability is available in Excel. You'd probably need to use some third party print driver, e.g. PDF Creator or Adobe itself.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks