SpellingOptions.IgnoreFileNames Property (Excel)

False instructs Microsoft Excel to check for Internet and file addresses, True instructs Excel to ignore Internet and file addresses when using the spell checker. Read/write Boolean.

expression .IgnoreFileNames

expression A variable that represents a SpellingOptions object.

In this example, Microsoft Excel determines what the setting is for checking spelling of Internet and file addresses and notifies the user.

Sub SpellingOptionsCheck() 
 
 If Application.SpellingOptions.IgnoreFileNames = True Then 
 MsgBox "Spelling options for checking Internet and file addresses is disabled." 
 Else 
 MsgBox "Spelling options for checking Internet and file addresses is enabled." 
 End If 
 
End Sub
Show:
© 2014 Microsoft