Results 1 to 6 of 6

Thread: How to avoid the Automatic Creation of Hyperlinks in Excel?

  1. #1
    Join Date
    Aug 2006
    Posts
    148

    How to avoid the Automatic Creation of Hyperlinks in Excel?

    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.!!
    The Gaming Machine:
    Processor: Core 2 Duo E6400
    Motherboard: Asus P5W DH Deluxe
    RAM: 2GB XMS2 Corsair PC2-6400
    Video: ATI Radeon X1900XT 512MB w/ Arctic Accellero
    Drive: 74GB "WD Raptor" 10000RPM
    Sound: Creative SoundBlaster X-Fi
    Watercooling: *Soon* Zalman Reserator

  2. #2
    Join Date
    May 2008
    Posts
    376

    Re: How to avoid the Automatic Creation of Hyperlinks in Excel?

    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:
    • \ \

  3. #3
    Join Date
    May 2008
    Posts
    353

    Re: How to avoid the Automatic Creation of Hyperlinks in Excel?

    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.

  4. #4
    Join Date
    Apr 2008
    Posts
    2,139

    Re: How to avoid the Automatic Creation of Hyperlinks in Excel?

    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

  5. #5
    Join Date
    Sep 2005
    Posts
    1,306

    Re: How to avoid the Automatic Creation of Hyperlinks in Excel?

    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.

  6. #6
    Join Date
    May 2008
    Posts
    4,345

    Re: How to avoid the Automatic Creation of Hyperlinks in Excel?

    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.

Similar Threads

  1. How to edit multiple hyperlinks of Excel at a single time
    By De-Dg in forum MS Office Support
    Replies: 5
    Last Post: 24-02-2012, 12:15 PM
  2. Is it possible to edit hyperlinks via vba in Excel
    By !Jumala! in forum MS Office Support
    Replies: 2
    Last Post: 23-02-2012, 12:07 PM
  3. Replies: 2
    Last Post: 17-02-2012, 05:36 PM
  4. How to move hyperlinks in Excel
    By Abel18 in forum Windows Software
    Replies: 5
    Last Post: 18-12-2009, 12:49 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,623,892.81096 seconds with 17 queries