Share via

Protection.AllowFormattingRows Property

  • Article
Excel Developer Reference

Returns True if the formatting of rows is allowed on a protected worksheet. Read-only Boolean.

Syntax

expression.AllowFormattingRows

expression   A variable that represents a Protection object.

Remarks

The AllowFormattingRows property can be set by using the Protect method arguments.

Example

This example allows the user to format the rows on the protected worksheet and notifies the user.

Visual Basic for Applications 
  Sub ProtectionOptions()

ActiveSheet.Unprotect

' Allow rows to be formatted on a protected worksheet.
If ActiveSheet.Protection.<strong>AllowFormattingRows</strong> = False Then
    ActiveSheet.Protect AllowFormattingRows:=True
End If

MsgBox "Rows can be formatted on this protected worksheet."



End Sub

See Also