![]() ![]() NET (C#, VB) that show how to protect a workbook. ![]() To open an existing Microsoft Excel file, protect the workbook with structure and Windows attributes and save the file.īelow are parallel code snippets for VSTO (C#, VB) and Aspose.Cells for. To protect the data, you must protect the worksheets. Unprotect Excel Workbook structure without password. Protecting a workbook does not stop users from editing cells. What you need to do is copy your macros else where, delete the macros, save the file without macros. NET to let you compare the two methods.Īspose.Cells works independently of Microsoft Office Automation and is developed to be easy to use and produce neat code. In this article, we show how to protect and unprotect workbooks using VSTO and Aspose.Cells for. To protect Windows so that they are the same size and position each time the workbook is opened, specify the ProtectionType as Windows. To protect a workbook’s structure so that worksheets in the workbook can’t be moved, deleted, hidden, unhidden, or renamed, and new worksheets can’t be inserted, specify the ProtectionType as Structure. To prevent someone from accidentally or deliberately changing, moving, or deleting worksheets, you can protect workbook elements with or without a password.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |