Excel.Application.AutoFormatAsYouTypeReplaceHyperlinks.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Application.AutoFormatAsYouTypeReplaceHyperlinks property (Excel)	vbaxl10.chm133281	vbaxl10.chm133281	Excel.Application.AutoFormatAsYouTypeReplaceHyperlinks	92c02556-f39a-7ca4-31f5-88a5c9da12ea	04/04/2019	medium

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.

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.

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

[!includeSupport and feedback]