Name

Protection Object

Synopsis

Path: Application  --  Range  --  Worksheet - Protection

Object

Properties

Protection

  • AllowDeletingColumns( ) As Boolean

  • AllowDeletingRows( ) As Boolean

  • AllowEditRanges( ) As AllowEditRanges

  • AllowFiltering( ) As Boolean

  • AllowFormattingCells( ) As Boolean

  • AllowFormattingColumns( ) As Boolean

  • AllowFormattingRows( ) As Boolean

  • AllowInsertingColumns( ) As Boolean

  • AllowInsertingHyperlinks( ) As Boolean

  • AllowInsertingRows( ) As Boolean

  • AllowSorting( ) As Boolean

  • AllowUsingPivotTables( ) As Boolean

When you protect a worksheet, Excel permits you to specify that certain operations are still permitted on unlocked cells. At the user level, this is done through the Protection dialog box. At the programming level, it is done through the properties of the Protection object.

Get Writing Excel Macros with VBA, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial