AutoFormatAsYouTypeReplaceHyperlinks Property

Microsoft Excel Visual Basic

AutoFormatAsYouTypeReplaceHyperlinks Property

       

True (default) if Microsoft Excel automatically formats hyperlinks as you type. False if Excel does not automatically format hyperlinks as you type. Read/write Boolean.

expression.AutoFormatAsYouTypeReplaceHyperlinks

expression   Required. An expression that returns one of the objects in the Applies To list.

Example

In this example, Microsoft Excel determines if the ability to automatically format hyperlinks as they are typed in is enabled and notifies the user.

Sub CheckHyperlinks()

    ' Determine if automatic formatting is enabled and notify user.
    If Application.AutoFormatAsYouTypeReplaceHyperlinks = True Then
        MsgBox "Automatic formatting for typing in hyperlinks is enabled."
    Else
        MsgBox "Automatic formatting for typing in hyperlinks is not enabled."
    End If

End Sub