+ Reply to Thread
Results 1 to 8 of 8

hyperlink not working when copied and pasted

  1. #1
    Forum Contributor
    Join Date
    06-27-2014
    Location
    bristol, england
    MS-Off Ver
    excel 2007
    Posts
    264

    hyperlink not working when copied and pasted

    hi guys is there a way using vba to copy and paste a hyperlink from a userform to a sheet, without actually losing the the link on the sheet it is copied to, the link works fine on the userform but when i copy data to a sheet it losses the hyperlink functionality.

    scouse13

  2. #2
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: hyperlink not working when copied and pasted

    Considering you have www.google.com in Cell 'A1' & you want to copy paste this to 'D5' with hyper links in place.. check below code as a sample

    Please Login or Register  to view this content.
    Regards
    Parth

    I appreciate your feedback. Hit * if u Like.
    Rules - http://www.excelforum.com/forum-rule...rum-rules.html

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,404

    Re: hyperlink not working when copied and pasted

    What does the comment about Google mean, please?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: hyperlink not working when copied and pasted

    If doing it manually, While pasting the data..

    Do PasteSpecial - Keep Source Formatting

  5. #5
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: hyperlink not working when copied and pasted

    Quote Originally Posted by AliGW View Post
    What does the comment about Google mean, please?
    Hello AliGW, just took an example in Excel google with hyperlink

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,404

    Re: hyperlink not working when copied and pasted

    Ah, I see - LOL! Thanks.

  7. #7
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: hyperlink not working when copied and pasted

    Quote Originally Posted by AliGW View Post
    Ah, I see - LOL! Thanks.
    Welcome Mam

  8. #8
    Forum Contributor
    Join Date
    06-27-2014
    Location
    bristol, england
    MS-Off Ver
    excel 2007
    Posts
    264

    Re: hyperlink not working when copied and pasted

    thanks Parth007, its getting late here in the uk, will have a try with the code in the morning, but when the data is copied over to the sheet each cell has a hyperlink to a different document, all i need is the hyperlinks that are copied to the cells is for them to be proper hyperlinks lol, will you code do that or did i not explain my problem properly.

    the Hyperlink works fine on the userform, when the data is saved to a sheet, it losses hyperlinks?

+ 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. How can I detect if something was copied and pasted?
    By patlsu02 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2015, 10:26 AM
  2. Replies: 3
    Last Post: 07-11-2015, 05:17 PM
  3. Replies: 3
    Last Post: 12-22-2014, 02:24 PM
  4. Deactivating Copied Cell after it is Pasted
    By Mordred in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2010, 01:07 PM
  5. Number Changes When Copied and Pasted
    By BSquared18 in forum Excel General
    Replies: 3
    Last Post: 05-04-2009, 05:52 PM
  6. [SOLVED] Pasted date in Excel 2003 is wrong e.g. 05-16-2006 is copied,05-15-2002 is pasted
    By Jaap van der Veen in forum Excel General
    Replies: 3
    Last Post: 08-11-2006, 09:10 AM
  7. [SOLVED] How do I protect a worksheet from being copied & pasted?
    By JJ in forum Excel General
    Replies: 3
    Last Post: 07-28-2005, 09:07 AM

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