PdfBatchUniqueProtect

Protect multiple pdf files at once with different passwords from Excel automatic | using VBA macro

Prerequisites

1. Python3
2. Microsoft Excel
3. PyPDF2

Configuration

• Locate protect.py, edit the Paths
• Locate Protect.xlsm, edit the Path in Module3

Usage

1. Copy the path to your folder that contains PDF you want to password protect
2. Paste under Source File Path in Protect.xlsm
3. Click List File
4. Assign Password for each PDFs
5. Click Set Password

Idea comes from

https://www.youtube.com/watch?v=5qA2uGLfmGE