Password Protect the VBA Project of Excel Workbook

Password Protect the VBA Project of Excel Workbook in C#

You can password protect the VBA (Visual Basic for Applications) Project of workbook with Aspose.Cells using VbaProject.Protect() method.

Sample Code

The following sample code loads the sample Excel file, accesses its VBA Project and protects it with a password. Finally it saves it as the output Excel file.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

//The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

//Load your source Excel file.
Workbook wb = new Workbook(dataDir + "samplePasswordProtectVBAProject.xlsm");

//Access the VBA project of the workbook.
Aspose.Cells.Vba.VbaProject vbaProject = wb.VbaProject;

//Lock the VBA project for viewing with password.
vbaProject.Protect(true, "11");

//Save the output Excel file
wb.Save(dataDir + "outputPasswordProtectVBAProject.xlsm");