+ Reply to Thread
Results 1 to 4 of 4

create links to all active sheets

  1. #1
    Registered User
    Join Date
    10-08-2016
    Location
    PAKISTAN
    MS-Off Ver
    OFFICE 2016
    Posts
    75

    create links to all active sheets

    I have excel workbook which contains more than 80 sheets , i want to create links to cell A2 in sheet1 to all active sheets at once

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: create links to all active sheets

    Not sure what you mean by "all active sheets". There is only one active sheet. Do you mean all visible sheets?

    Try something like this...

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    10-08-2016
    Location
    PAKISTAN
    MS-Off Ver
    OFFICE 2016
    Posts
    75

    Re: create links to all active sheets

    all visible sheets

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: create links to all active sheets

    Did Alphafrog's code give you the answer? In which case, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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] Find links to current active worksheet
    By willastrowalker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-01-2018, 08:06 PM
  2. [SOLVED] VBA to creating active links in cells
    By Sebas1986 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-10-2016, 10:30 AM
  3. Replies: 1
    Last Post: 07-23-2014, 04:33 AM
  4. Find next available row based on a range then create links between two sheets
    By Titchy Dean in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-04-2012, 07:20 PM
  5. Get list of active links
    By Glennww in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-19-2010, 01:00 AM
  6. updating links only for the active sheet
    By alpertheidiot in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-15-2009, 07:24 AM
  7. How to keep links active between 2 different workbooks
    By bodem96 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2005, 03:58 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