How to avoid the Automatic Creation of Hyperlinks in Excel?

[sivaranjan]

Hi friends,
I have recently started with the Visual Basic Applications that are used in MS Excel. Many times I have observed that hyperlinks gets created automatically in an Excel. I am using Mac as operating system, and I don't think that OS is the issue. So please tell me how to avoid the Automatic Creation of Hyperlinks in Excel? Expecting your help as soon as possible.!!

[HellBoy21]

I would like to tell you some basic things about the hyperlinks. When you type an entry in your worksheet that begins with the following prefixes, which may be a valid hyperlink in style, Microsoft Excel for Mac automatically creates a hyperlink :

• http://
• www.
• mailto:
• FTP: / /
• file: / /
• News:
• \ \

[Kirmiac]

Excel for Mac also creates a hyperlink when you type an email address in the following format :

• user name @ company name. com

Excel for Mac does not provide built-in method to override this behavior. According to me Excel for Mac does not automatically converted to hyperlinks. However, the effects of the macro applies only during your current session of Excel for Mac.

[chroma]

To prevent Excel for Mac automatically create a hyperlink, you can use the following method :
You can type an apostrophe ( ') to avoid a hyperlink which is created when you create an entry cell. For example, Excel for Mac automatically creates a hyperlink when you type the following text in a cell :
http://support.microsoft.com
However, Excel for Mac does not automatically create a hyperlink when you type the following :
'Http://support.microsoft.com

[kattman]

You can also use an event handler program level to ensure that hyperlinks.

1. Save and close any open workbooks and then create a new workbook.
2. In the Tools menu, point to Macro and click Visual Basic Editor.
3. On the Insert menu, click Class Module.
4. Then you will have to type an appropriate code in the module sheet.
5. Click the Project Explorer window, then double-click the ThisWorkbook property.
6. In the Excel menu in Microsoft Excel X for Mac and later versions of Excel for Mac or the File menu in Microsoft Excel 2001 for Mac, click Close and Return to Microsoft Excel..
7. Save the file.
8. In the Tools menu, point to Macro and click Visual Basic Editor.
9. Place the insertion point anywhere in the code "Workbook_Open.
10. In the Standard toolbar, click Run Sub / UserForm to run the macro "Workbook_Open. You can also press F5 to run the macro.

[JonathanD]

I would like to suggest you to use the VBA in Excel for avoiding an automatic creation of hyperlink. You can use an event handler level program to delete the existing links and to prevent Excel for Mac automatically creating hyperlinks. You can do that by the steps explained by the 'kattman'. The only way this macro removes an existing hyperlink is select the cell and click on the text in the formula bar to activate the cell and then press ENTER. This method is ideal to use when you want to prevent new hyperlinks but do not want to accidentally remove existing hyperlinks. This procedure does not use the function HYPERLINK worksheet to create hyperlinks.