Assign Macro to Form Control

Aspose.Cells allows you to assign a Macro Code to a Form Control like a Button. Please use the Shape.MarcoName property to assign a new Macro Code to a Form Control inside the workbook.

The following sample code creates a new workbook, assign a Macro Code to a Form Button and saves the output in the XLSM format. Once, you will open the output XLSM file in Microsoft Excel you will see the following macro code.

 Sub ShowMessage()

    MsgBox "Welcome to Aspose!"

End Sub

Assign Macro to Form Control in C#

Here is the sample code to generate the output XLSM file with Macro Code.

Check if VBA Project is Protected and Locked for Viewing Check if VBA project in a Workbook is Signed