1. API Reference
  2. /
  3. GroupDocs.Signature
  4. /
  5. GroupDocs.Signature for Python via .NET
  6. /
  7. groupdocs.signature.domain.extensions
  8. /
  9. DigitalVBA class

DigitalVBA class

On this page

DigitalVBA class

Represents digital signature for Spreadsheets VBA projects.

Provides ability to sign a VBA project in spreadsheet document formats such as Xlsm or Xltm. If multiple DigitalVBA extensions are added to DigitalSignOptions.extensions, only the first is used during signing.

The DigitalVBA type exposes the following members:

Constructors

Constructor Description
init Initializes a new instance of the DigitalVBA class with a certificate file.
init Initializes a new instance of the DigitalVBA class with a certificate stream.

Methods

Method Description
clone Gets a copy of this object. (inherited from SignatureExtension)

Properties

Property Description
certificate_file_path The digital certificate file path, used only if CertificateStream is not specified.
certificate_stream The digital certificate stream. If this property is specified it is always used instead of CertificateFilePath.
comments The signature comments.
password The password of the digital certificate.
sign_only_vba_project The setting that determines whether only the VBA project is signed. When True, the spreadsheet document itself is not signed; only the VBA project is signed.

Example 

import zipfile
from groupdocs.signature import Signature
from groupdocs.signature.domain.extensions import DigitalVBA
from groupdocs.signature.options import DigitalSignOptions


def sign_spreadsheet_macros_only():
    # Sign macros within the spreadsheet
    with Signature("sample.xlsm") as signature:
        sign_options = DigitalSignOptions()

        # Add extension for signing VBA project digitally
        digital_vba = DigitalVBA("certificate.pfx", "1234567890")
        digital_vba.sign_only_vba_project = True
        digital_vba.comments = "Signed VBA macros"
        sign_options.extensions.append(digital_vba)

        result = signature.sign("signed_macros.xlsm", sign_options)
        print(f"Signatures added: {len(result.succeeded)}")

    # Verify that the VBA project signature part was added
    with zipfile.ZipFile("signed_macros.xlsm") as package:
        print("VBA project signed:", "xl/vbaProjectSignature.bin" in package.namelist())

See Also

On this page

© Groupdocs 2001-2026. All Rights Reserved.