+ Reply to Thread
Results 1 to 3 of 3

When pasting links, how to make them become hyperlinks automatically?

  1. #1
    Registered User
    Join Date
    08-18-2020
    Location
    england
    MS-Off Ver
    Excel 2016
    Posts
    44

    When pasting links, how to make them become hyperlinks automatically?

    At the moment what i do is press spacebar after pasting which turns them into hyperlinks but i'm wondering is there any way to automatically make them hyperlinks without pressing spacebar?

    E.g. Is there a vba module that does this?

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: When pasting links, how to make them become hyperlinks automatically?

    A macro to do this would be less efficient to use than simply adding the space after the hyperlink.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    08-18-2020
    Location
    england
    MS-Off Ver
    Excel 2016
    Posts
    44

    Re: When pasting links, how to make them become hyperlinks automatically?

    Fair point

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 04-22-2016, 08:12 AM
  2. Copy/pasting hyperlinks with links
    By bjartmare in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-27-2015, 08:05 AM
  3. [SOLVED] Pasting Hyperlinks Into New Workbook
    By VBA FTW in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-17-2012, 10:33 AM
  4. Cell that links to two possible hyperlinks?
    By djmarak in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-24-2007, 10:14 AM
  5. [SOLVED] how to get rid of hyperlinks when cutting and pasting e-mail addre
    By Mike Nolan in forum Excel General
    Replies: 3
    Last Post: 06-15-2006, 08:20 AM
  6. [SOLVED] Can we update links automatically somehow after making a copy of a sheet with links?
    By StargateFanFromWork in forum Excel General
    Replies: 4
    Last Post: 12-08-2005, 05:40 PM
  7. Replies: 0
    Last Post: 01-12-2005, 10:06 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1