Password Protecting PDF via Excel

[TemiU]

Hello all Excel Experts!

I have VBA code which uses the .ExportAsPDF method to export my workbook to a PDF file.

I need to be able to password protect that PDF file so that it can not be modified. I can do this either with VBA or by running external (DOS) code.

Does anyone have any suggestions?

 

[mole999]

something in this thread maybe > http://www.mrexcel.com/forum/excel-questions/593415-password-protected-pdf-file.html

 

[TemiU]

I need to be able to do it without third party apps, since other users will be running the code and will not necessarily have the same apps I do.

 

[mole999]

its simple search > How to Password Protect Documents and PDFs with Microsoft Office so it should be programmable

 

[TemiU]

Using the ExportAsFixedFormat method does not allow for a protection option. Also, it looks like Excel 2013 doesn't give the option to protect the file as outlined in the article above (when publishing using File->Export or File->Save As).

I wanted to know if, perhaps, anyone had some sort of code that I could run to "manually" encrypt the file.

 

[TemiU]

Actually what I need to do is make the file read only. The password is less important.

 

[TemiU]

Okay, I found code to make the file read only at this site:

VBA Tips & Tricks: How to Make a File ReadOnly using Excel VBA