Digitally Sign a VBA Code Project with Certificate

You can digitally sign your VBA code project using Aspose.Cells for Python via .NET with its Workbook.vba_project.sign() method. Please follow these steps to check if your excel file is digitally signed with a certificate.

• Click Visual Basic from the Developer tab to open Visual Basic for Applications IDE
• Click Tools > Digital Signatures…  of Visual Basic for Applications IDE

and it will show the Digital Signature Form showing if the document is digitally signed with a certificate or not.

Digitally Sign a VBA Code Project with Certificate in Python

The following sample code illustrates how to make use of Workbook.vba_project.sign() method. Here are the input and output files of the sample code. You can use any excel file and any certificate to test this code.

• Source Excel file used in the sample code.
• Sample pfx file to create Digital Signature. Please install it on your computer to run this code. Its password is 1234.
• Output Excel file generated by the sample code.

from aspose.cells import Workbook
from aspose.cells.digitalsignatures import DigitalSignature
from datetime import datetime

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
password = "1234"
pfxPath = sourceDir + "sampleDigitallySignVbaProjectWithCertificate.pfx"
comment = "Signing Digital Signature using Aspose.Cells"
#  Set Digital Signature
digitalSignature = DigitalSignature(open(pfxPath, "rb").read(), password, comment, datetime.now())
#  Create workbook object from excel file
workbook = Workbook(sourceDir + "sampleDigitallySignVbaProjectWithCertificate.xlsm")
#  Sign VBA Code Project with Digital Signature
workbook.vba_project.sign(digitalSignature)
#  Save the workbook
workbook.save(outputDir + "outputDigitallySignVbaProjectWithCertificate.xlsm")