Digitally Sign a VBA Code Project with Certificate

You can digitally sign your VBA code project using Aspose.Cells with its Workbook.VbaProject.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 C#

The following sample code illustrates how to make use of Workbook.VbaProject.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.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
string password = "1234";
string pfxPath = sourceDir + "sampleDigitallySignVbaProjectWithCertificate.pfx";
string comment = "Signing Digital Signature using Aspose.Cells";

// Set Digital Signature
DigitalSignature digitalSignature = new DigitalSignature(File.ReadAllBytes(pfxPath), password, comment, DateTime.Now);

// Create workbook object from excel file
Workbook workbook = new Workbook(sourceDir + "sampleDigitallySignVbaProjectWithCertificate.xlsm");

// Sign VBA Code Project with Digital Signature
workbook.VbaProject.Sign(digitalSignature);

// Save the workbook
workbook.Save(outputDir + "outputDigitallySignVbaProjectWithCertificate.xlsm");