Share via

Protection.AllowInsertingHyperlinks Property

  • Article
Excel Developer Reference

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

Syntax

expression.AllowInsertingHyperlinks

expression   A variable that represents a Protection object.

Remarks

Hyperlinks can only be inserted in unlocked or unprotected cells on a protected worksheet.

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

Example

This example allows the user to insert a hyperlink in cell A1 on the protected worksheet and notifies the user.

Visual Basic for Applications 
  Sub ProtectionOptions()

ActiveSheet.Unprotect

' Unlock cell A1.
Range("A1").Locked = False

' Allow hyperlinks to be inserted on a protected worksheet.
If ActiveSheet.Protection.<strong>AllowInsertingHyperlinks</strong> = False Then
    ActiveSheet.Protect AllowInsertingHyperlinks:=True
End If

MsgBox "Hyperlinks can be inserted on this protected worksheet."



End Sub

See Also