+ Reply to Thread
Results 1 to 4 of 4

copy hyperlink from cell from one sheet to another in shared mode.

  1. #1
    Registered User
    Join Date
    11-17-2012
    Location
    Bremerton, WA
    MS-Off Ver
    Excel 2010
    Posts
    2

    copy hyperlink from cell from one sheet to another in shared mode.

    My code works but not in shared mode. I have searched for answers and tried many suggestions but can't manage to get an answer so thought I would join a forum and give it a try. Basically, I use a form to ask for a name and search all the sheets for that name and copy a few cells to a new sheet for a report or case list. The first column on each sheet is a case number that links to the case file folder. The links are added out of shared mode due to shared mode restrictions. I just want to copy pre-exsiting links to a new sheet. The line in the ELSE section copies everything over in shared mode but you cannot follow the link hense why I thought to seperate lines with a link and without. Any Ideas or help much appreciated. Please see my Find cases code below.

    Please Login or Register  to view this content.
    Moderators note: code tags added for you - this time
    Last edited by FDibbins; 11-17-2012 at 04:52 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: copy hyperlink from cell from one sheet to another in shared mode.

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-17-2012
    Location
    Bremerton, WA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: copy hyperlink from cell from one sheet to another in shared mode.

    newbee here, will get it right next time. TY

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: copy hyperlink from cell from one sheet to another in shared mode.

    thats ok, thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1