+ Reply to Thread
Results 1 to 4 of 4

Creating hyperlink automatically from cell to sheet

  1. #1
    Registered User
    Join Date
    02-08-2019
    Location
    Ålesund, Norway
    MS-Off Ver
    Excel 365
    Posts
    12

    Creating hyperlink automatically from cell to sheet

    Hello guys,

    I have created alot of sheets based on cell values. Now I want to automatically create hyperlinks in the cells that directs me to the sheet with the same name.

    Does anyone in here have a script for this, or anything that can point me in the rigth direction? I am new to VBA, but it is superuseful in my daily worklife.

    Best regards
    Jan Inge

  2. #2
    Valued Forum Contributor
    Join Date
    01-14-2013
    Location
    Austria
    MS-Off Ver
    2016 / 2019
    Posts
    339

    Re: Creating hyperlink automatically from cell to sheet

    Please Login or Register  to view this content.
    I attached a sample file. Only thing is that a worksheet with name "Content" must be available (or change name)
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-08-2019
    Location
    Ålesund, Norway
    MS-Off Ver
    Excel 365
    Posts
    12

    Re: Creating hyperlink automatically from cell to sheet

    This works absolutely great, thank you .

    I have two more questions if it is ok for you:

    1. Is there anyway to edit this so it only makes hyperlink from cell A6-A999, instead of deleting all other info in sheet?
    2. Is it possible to run this all the time, so when you add a new sheet or cell is comes up automatically?

    Again, thank you.

    //JIO

  4. #4
    Valued Forum Contributor
    Join Date
    01-14-2013
    Location
    Austria
    MS-Off Ver
    2016 / 2019
    Posts
    339

    Re: Creating hyperlink automatically from cell to sheet

    of course
    1) from A6 down, so there is data above which should not be erased, but why limited to A999? Is there data below? if not then I would propose to delete everything down from A6.
    - above A6 is data and no hyperlinks to sheets? --> then the destination address has to be change to "A6"

    Please Login or Register  to view this content.
    2) there is a workbook event that can trigger the macro
    Please Login or Register  to view this content.
    But if you afterwards rename a worksheet then you have to trigger it manually.

    I have found something on the internet but this means you have to add the class to the workbook and additionally the function Worksheet_Activate() on every sheet
    https://stackoverflow.com/questions/...event-in-excel

+ 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. Hyperlink Cell name / sheet name - to change automatically
    By RAJRAJ85 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-10-2019, 09:11 AM
  2. [SOLVED] Creating Hyperlink to a variable sheet name
    By Tpleme in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-24-2017, 07:25 AM
  3. Replies: 0
    Last Post: 08-11-2016, 07:42 AM
  4. [SOLVED] Creating Hyperlink to new sheet
    By rigby in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-28-2013, 02:10 AM
  5. How to automatically copy cell with hyperlink from one sheet to the other
    By shalhevet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2013, 05:48 PM
  6. [SOLVED] Automatically create hyperlink in active cell when creating folders
    By XxCMoneyxX in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-06-2013, 12:04 PM
  7. Replies: 48
    Last Post: 09-27-2012, 12:27 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