Unfortunately, VBA doesn't have built-in methods to work PDF files. A work around is to use a 3rd-party software or if you know other programming languages like Java, Python, C#, etc, then it is a simple task to apply PDF password to a set of files.

Here's a video reference to add a password to a PDF file using Python https://youtu.be/KGJ1LMTOefY.