User-friendly, affordable, and packed with different features, DocHub is a healthy and cost-efficient alternative to Smartwaiver. Try it now and learn how to squeeze the maximum of our solution with easy-to-use feature shortcuts.
In this video tutorial, the presenter demonstrates how to use VBA to encrypt PDF files. Before starting, the viewer needs to download an "encrypt pdf.exe" file, a command line tool created using Python for encrypting PDF files with passwords. In an Excel spreadsheet, the presenter has file paths in column A and passwords in column B for three PDF files. It is recommended to backup PDF files before running the macro. The VBA window is opened by going to the developer tab and clicking on visual basic. A new module is inserted, and a macro named "encrypt pdfs" is created with variables for file name and row number. The worksheet is named "ws_list" for referencing the worksheet object.