Excel to PDF Print (with security)


New Member
Jun 18, 2019

I have been using the information posted here to generate PDF files for invoices (works well btw, thanks!).
My only concern is that the PDF (output file) contains a digital signature (scanned PNG), which can be extracted from the PDF via copy/paste.

Is there a way to automatically protect the pdf file to prevent that? Something along the lines of win2pdf[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif] which adds that security to the regular Print to PDF printer objects.
maybe leveraging this feature as a part of the VB script? I am willing to pay for the win2PDF app.

There is a similar product (Apdf) that runs as a service, but a bit more expensive.

Note: I dont want to restrict printing, just copying parts of the PDF.

Thanks in advance,

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...