How do I create PDF with password protection using Excel/VBA

Forum|Forum|9 years ago
March 20, 2017
3 replies
8928 views

I have a program that creates Excel files and converts them to PDF (Export As Fixed Format). Now I need to add password on open to the PDF files. How do I do that? Any help would be recommended.

Also, on a similar note printing word to pdf has encrypt with password feature but printing excel to pdf does not. Highly recommend you add this feature to PDF.

This topic has been closed for replies.

T

Test Screen Name

Legend

Reader is just a reader. To make files or set security you need Acrobat (paid for).

I guess from your question you're creating a PDF eithout using any Adobe product... So it's hard to answer what features you have, or respond to your suggestion.

T

Test Screen Name

Legend

Sorry, I mean no PROGRAMMING Interface. Indeed, there is no supported API for scripting PDFMaker at all.

Bernd Alheit

Community Expert

Nothing to add. The feature is available in PDF.

S

siddharth147Author

Participant

Thanks Bernd,

Sorry what I meant to ask was how to save an excel file as PDF With Password Protection using VBA macros. I know how to save as PDF without password protection as feature is available but cannot see an option to save with password protection.

Any suggestion?

T

Test Screen Name

Legend

Acrobat has no interface for this.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded