The following table describes the properties of the Protection object. AllowDeletingColumns Delete columns on a protected worksheet. Delete rows on a protected worksheet. Yes AllowFormattingCells Format cells on a protected worksheet. Yes AllowFormattingColumns Format columns on a protected worksheet.
Format rows on a protected worksheet.
Yes AllowInsertingColumns Insert columns on a protected worksheet. Insert rows on a protected worksheet. AllowInsertingHyperlinks Insert hyperlinks on a protected worksheet. Yes AllowFiltering Use AutoFilter on a protected worksheet. Yes AllowSorting Sort cells on a protected worksheet.