NativeExcel for .Net Developer's Reference

IProtection.AllowDeletingColumns Property

Gets or sets a value that indicates whether the deletion of columns is allowed on a protected worksheet.

[Visual Basic]
PropertyAllowDeletingColumnsAsBoolean
[C#]
boolAllowDeletingColumns{get;set;}
[C++]
__propertyboolget_AllowDeletingColumns();
__propertyvoidset_AllowDeletingColumns(bool);
[JScript]
functiongetAllowDeletingColumns():bool
functionsetAllowDeletingColumns(bool);

Property Value

True if the deletion of columns is allowed. The columns containing the cells to be deleted must be unlocked when the sheet is protected.

Example

This example changes AllowDeletingColumns property for sheet one

[C#]
book.Worksheets[1].Protection.AllowDeletingColumns = true;
[VisualBasic]
book.Worksheets(i).Protection.AllowDeletingColumns = True
[C++]
book->Worksheets->Item[i]->Protection->AllowDeletingColumns = true;

See Also

IProtection Interface | NativeExcel Namespace | Protection Property