Article ID: 233073 - View products that this article applies to.
This article was previously published under Q233073
For a Microsoft Excel 2002 and later versions of Excel version of this article, see 291209
For a Microsoft Excel for Macintosh version of this article, see 323238
When you type an entry in your worksheet that begins with any of the following prefixes, Microsoft Excel creates a hyperlink:
user name@company name.comExcel does not provide a built-in method to override this behavior. However, this article contains two sample methods that you can use to prevent Excel from automatically creating hyperlinks.
To prevent Excel from automatically creating a hyperlink, use either of the following methods.
Method 1: Type an apostrophe at the beginning of the cell entryYou can type an apostrophe (') to prevent a hyperlink from being created when you make a cell entry. For example, Excel will automatically create a hyperlink when you type the following text in a cell:
http://support.microsoft.comHowever, Excel will not automatically create a hyperlink when you type the following text:
Method 2: Use an application-level event handlerMicrosoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. The following steps illustrate how to use an application-level event handler to prevent Excel from automatically creating a hyperlink.
Note This procedure does not prevent the use of the HYPERLINK worksheet function to create hyperlinks.
For more information about how to create hyperlinks, click Microsoft Excel Help on the Help menu, type create a hyperlink in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Article ID: 233073 - Last Review: May 12, 2006 - Revision: 5.0
Contact us for more help