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

[Visual Basic]
Property AllowDeletingColumns As Boolean
[C#]
bool AllowDeletingColumns { get; set; }
[C++]
__property bool get_AllowDeletingColumns();
__property void set_AllowDeletingColumns(bool );
[JScript]
function get AllowDeletingColumns() : bool
function set AllowDeletingColumns(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;

[Visual Basic]
book.Worksheets(i).Protection.AllowDeletingColumns = True

[C++]
book->Worksheets->Item[i]->Protection->AllowDeletingColumns = true;

See Also

IProtection Interface | NativeExcel Namespace | Protection Property

---