These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

How to Create PDF from Excel with Password?

Forum Index > PDF Creation > How to Create PDF from Excel with Password?
2011-02-03 17:00:14
nowhere
Registered: Feb 3 2011
Posts: 4

Hi
 
I have written a macro to convert active sheet to PDF file by using PDF printer. However, I would like to know whether it is possible to set password for the PDF file when doing the conversion?
 
Thanks!

Top
2011-02-03 17:06:13
#1
George_Johnson
Online
Expert
Registered: Jul 6 2008
Posts: 1875
You can specify security settings in Distiller by launching it and selecting the "Settings > Security..." menu item. But all files you create will get the same settings.
Top
2011-02-03 17:21:40
#2
nowhere
Registered: Feb 3 2011
Posts: 4
thanks for your reply. Could you tell me more details on how to add the code to auto set the password, thanks!
Top
2011-02-03 18:16:41
#3
George_Johnson
Online
Expert
Registered: Jul 6 2008
Posts: 1875
No code is needed for the method I mentioned. Have you tried it?
Top
2011-02-03 18:19:43
#4
nowhere
Registered: Feb 3 2011
Posts: 4
you mean all the PDF file will have the same password? thanks!
Top
2011-02-07 06:33:49
#5
nowhere
Registered: Feb 3 2011
Posts: 4
what i want to set different password for different converted pdf file when doing the conversion. the password can be linked to a password list for different file name. Anyone has idea whether it is doable?
Top