AllowInsertingHyperlinks Property

Microsoft Excel Visual Basic

expression.AllowInsertingHyperlinks

expression    Required. An expression that returns 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.

Sub ProtectionOptions()

    ActiveSheet.Unprotect

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

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

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

End Sub