Protection.AllowInsertingHyperlinks Property

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.

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

See also:

• Protection Object
• Protection Object Members