+ Reply to Thread
Results 1 to 4 of 4

VBA Convert Sheet Names to HyperLink Go To Cell C11

  1. #1
    Forum Contributor
    Join Date
    02-26-2023
    Location
    Lousianna
    MS-Off Ver
    Microsoft 365
    Posts
    932

    VBA Convert Sheet Names to HyperLink Go To Cell C11

    Hi,

    I have list of certain sheet names that I want to convert to hyperlinks that will go to cell C11 in each of the sheets.

    Is this possible to to with VBA?

    Thank you
    Last edited by billy60; 09-28-2023 at 09:22 AM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,206

    Re: VBA Convert Sheet Names to HyperLink Go To Cell C11

    If this is a follow-on from your previous post on hyperlinks, Set C11 to cell reference in the hyperlink rather than default of A1
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Valued Forum Contributor
    Join Date
    12-30-2020
    Location
    Odessa / Ukraine
    MS-Off Ver
    2021
    Posts
    301

    Re: VBA Convert Sheet Names to HyperLink Go To Cell C11

    Hello @billy60. Maybe like this?
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    02-26-2023
    Location
    Lousianna
    MS-Off Ver
    Microsoft 365
    Posts
    932

    Re: VBA Convert Sheet Names to HyperLink Go To Cell C11

    Yes follow up on the other. Every hyperlink is going to Job-001 cell A1.

    This is why I asked to convert.

+ 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. [SOLVED] Get File names , path from folders & hyperlink to the files in excel sheet with excelvba
    By sanjuss2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2021, 08:51 AM
  2. List Sheet Names but Do Not Include Hyperlink - Augment existing code
    By wherdzik in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-26-2020, 02:05 PM
  3. [SOLVED] macro creates new sheet and names it, need to create hyperlink to new sheet on main sheet
    By cjburns in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-03-2020, 11:26 AM
  4. Hyperlink to hidden sheet using a cell with the =Hyperlink formula
    By pauldonnelly16 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-23-2018, 07:53 PM
  5. Hyperlink Macro that converts a list of sheet names to hyperlinks to the sheets
    By holt3130 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2013, 08:49 AM
  6. convert cell value to hyperlink
    By clomper in forum Excel General
    Replies: 6
    Last Post: 11-09-2009, 03:52 PM
  7. Convert Hyperlink to cell value automatically
    By Convert Hyperlinks in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-25-2006, 05:55 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