Application.AutoFormatAsYouTypeReplaceHyperlinks property (Excel)

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 A variable that represents an Application object.


In this example, Microsoft Excel determines if the ability to format hyperlinks automatically as they are typed 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." 
 MsgBox "Automatic formatting for typing in hyperlinks is not enabled." 
 End If 
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.