Sign VBA macroses with Digital signature Leave feedback

GroupDocs.Signature provides DigitalSignOptions class to specify different amount of settings for Digital signature

• Class DigitalVBA allows to configure certificate settings for macros signing

Here are the steps to add Digital signature into document with GroupDocs.Signature:

• Create new instance of Signature class and pass source Excel document path as a constructor parameter.
• Instantiate the DigitalSignOptions object
• Instantiate the DigitalVBA object with certificatePath and password.
• Call Sign method of  Signature class instance and pass DigitalSignOptions to it.

This example shows how to add Digital signature to document. See SignResult

 using (Signature signature = new Signature(excelFilePath))
{
     DigitalSignOptions signOptions = new DigitalSignOptions();
    //Add extension for signing VBA project digitally
    DigitalVBA digitalVBA = new DigitalVBA(certificatePath, password);
    //Set to true only for signing VBA project
    digitalVBA.SignOnlyVBAProject = true;
    digitalVBA.Comments = "VBA Comment";
    signOptions.Extensions.Add(digitalVBA);

    // sign document to file
    SignResult signResult = signature.Sign(outputFilePath, signOptions);
}

You may easily run the code above and see the feature in action in our GitHub examples:

• Sign Spreadsheet document with macro support and VBA Project in it

Along with the full-featured .NET library, we provide simple but powerful free online apps.

To sign PDF, Word, Excel, PowerPoint, and other documents you can use the online apps from the GroupDocs.Signature App Product Family.