Copy link to clipboard
Copied
I have a form with fields that have been filled using Excel VBA. I want to lock the form down using Excel VBA code (more than just setting the form fields to read only). I have found two manual solutions: 1) Set Document Properties to Password Security and restrict editing assign a password and not allow any changes. 2) Print my completed form selecting Adobe PDF as my Printer.
I have not been able to find a way to code either of these options. I would greatly appreciate help with either approach and/or some third option that achieves the same goal of a completely locked PDF generated using Excel VBA. Thank you!
Copy link to clipboard
Copied
I have a form with fields that have been filled using Excel VBA. I want to lock the form down using Excel VBA code (more than just setting the form fields to read only). I have found two manual solutions: 1) Set Document Properties to Password Security and restrict editing assign a password and not allow any changes. 2) Print my completed form selecting Adobe PDF as my Printer.
I have not been able to find a way to code either of these options. I would greatly appreciate help with either approach and/or some third option that achieves the same goal of a completely locked PDF generated using Excel VBA. Thank you!
Have something to add?