Advanced Protection


#1

Hi,

I need to be able to protect a worksheet but also allow row insertions. If I go through Excel, the protection dialog gives me a list of allowable user actions that I can check, including “Insert rows”. Is there a way to enable the same protection through Aspose?

Thanks,
Mark


#2

Hi Mark,

Do you use ExcelXP or Excel2003? Please use Worksheet.Protection property for this purpose.

Excel excel = new Excel();
excel.Worksheets[0].Protection.IsInsertingRowsAllowed = true;