I am trying to run a macro which creates a pdf which work fine. When the excel file gets signed, the excel file gets automatically protected.
Problem: I have a button on the worksheet which needs to be pressed to create the pdf documnet. However this can not be done because the button has also got protected and cant be press. Is there anyway around this?
However if i try save the excel file as manaully as pdf it works.
Points to bear in mind
If the worksheet gets unprotected the signatures get removed.
Small around that will not delete the signatures
If the excel sheet is saved as a different name the signatures remain. So if i am able to get the button to work . The workbook could be saved as different name ( in macro), and then save as pdf which will contain signatures.