+ Reply to Thread
Results 1 to 5 of 5

Creating Hyperlink to new sheet

  1. #1
    Registered User
    Join Date
    11-26-2013
    Location
    home
    MS-Off Ver
    Excel 2010
    Posts
    3

    Cool Creating Hyperlink to new sheet

    Hello,

    Im new to excel macros and Ive currently hit a brick wall, I want to put together a workbook that allows me to input a new vehicle number on sheet one, ( this sheet I am calling Vehicles ) then popup with a prompt that allows me choose whether to create a new sheet to store relevant service info on that vehicle. This newly created sheet will be a replica of my template sheet.

    below is the current macro I have been using.


    Please Login or Register  to view this content.
    However when It creates the new sheet I want it to take the text from the original cell, turn this into a hyperlink that links to the newly created sheet, I have been trying to work around this for a few hours now without luck, could anyone here kindly help me out?

    thanks

    Dan
    Last edited by rigby; 11-26-2013 at 03:58 PM.

  2. #2
    Registered User
    Join Date
    11-26-2013
    Location
    home
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Creating Hyperlink to new sheet

    Post edited to comply with site rules, sorry about that..

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: Creating Hyperlink to new sheet

    Try this code…

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    11-26-2013
    Location
    home
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Creating Hyperlink to new sheet

    Worked perfectly the first time I applied it, thank you.

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: Creating Hyperlink to new sheet

    Glad it helps you and thanks for the feedback and rep

+ 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: 1
    Last Post: 02-23-2013, 05:18 AM
  2. Hyperlink Creating
    By kmoon1968 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-21-2011, 10:55 PM
  3. Problem in creating hyperlink
    By hamid4777 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2011, 12:02 PM
  4. Creating button as a hyperlink
    By Hall in forum Excel General
    Replies: 1
    Last Post: 11-15-2005, 06:00 PM
  5. [SOLVED] Help with creating hyperlink via VBA
    By FrigidDigit in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-19-2005, 02:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1