Export (0) Print
Expand All
Expand Minimize

Application.AutoFormatAsYouTypeReplaceHyperlinks Property

Office 2007
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.

Syntax

expression.AutoFormatAsYouTypeReplaceHyperlinks

expression   A variable that represents an Application object.

Example

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

Visual Basic for Applications
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



Community Additions

ADD
Show:
© 2014 Microsoft