+ Reply to Thread
Results 1 to 9 of 9

Hyperlinking to hidden tabs - hidden tabs unhide / hide automatically.

  1. 10-30-2016, 06:24 AM #1
    jexcelio
    jexcelio is offline
    Registered User
    Join Date
    10-30-2016
    Location
    Doha
    MS-Off Ver
    2010
    Posts
    8

    Hyperlinking to hidden tabs - hidden tabs unhide / hide automatically.

    Hi.

    I have a workbook with multiple tabs.

    The first two are unhidden, the second tab contains a column of hyperlinks. The hyperlinks lead to data contained in hidden tabs.

    Is there a VBA code so that when the user clicks on a hyperlink, the selected hidden tab auto unhides for the user to read that data. After viewing the information, the user clicks back to any other open tab which results in the previous tab automatically reverting back to hidden.

    I'm amateur to this and have tried a few random vba codes from other forums without success. After putting the codes in to a module, I would try to run the code but the macro was not showing in the macro list.

    Thankyou to anyone who responds.

    Jonathan =]
    Last edited by jexcelio; 10-31-2016 at 01:32 AM.
    Reply With QuoteRegister To Reply
  2. 10-30-2016, 07:05 AM #2
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Hyperlinking to hidden tabs - hidden tabs unhide / hide automatically.

    This for Sheet 2

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Reply With QuoteRegister To Reply
  3. 10-30-2016, 07:16 AM #3
    jexcelio
    jexcelio is offline
    Registered User
    Join Date
    10-30-2016
    Location
    Doha
    MS-Off Ver
    2010
    Posts
    8

    Re: Hyperlinking to hidden tabs - hidden tabs unhide / hide automatically.

    Thanks Leo.

    Could you highlight in bold the font where I should input the data specific to my spreadsheet?
    Reply With QuoteRegister To Reply
  4. 10-30-2016, 07:32 AM #4
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Hyperlinking to hidden tabs - hidden tabs unhide / hide automatically.

    open VBA
    open sheet 2
    there you paste the code

    Change the red 3 to columnnumber were are the sheet names

    Please Login or Register  to view this content.
    can also post your file and i do it for you

    Kind regards
    Leo
    Reply With QuoteRegister To Reply
  5. 10-30-2016, 10:50 AM #5
    jexcelio
    jexcelio is offline
    Registered User
    Join Date
    10-30-2016
    Location
    Doha
    MS-Off Ver
    2010
    Posts
    8

    Re: Hyperlinking to hidden tabs - hidden tabs unhide / hide automatically.

    Hi Leo,

    I will PM you with DL file.

    Thanks!
    Reply With QuoteRegister To Reply
  6. 10-30-2016, 06:41 PM #6
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Hyperlinking to hidden tabs - hidden tabs unhide / hide automatically.

    2 codes, both in Workbook
    1 in Workbook SheetActivate
    1 in Workbook SheetSelectionChange

    to go to desired sheet just select in column B

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Last edited by LeoTaxi; 10-31-2016 at 04:44 AM.
    Reply With QuoteRegister To Reply
  7. 10-31-2016, 01:25 AM #7
    jexcelio
    jexcelio is offline
    Registered User
    Join Date
    10-30-2016
    Location
    Doha
    MS-Off Ver
    2010
    Posts
    8

    Re: Hyperlinking to hidden tabs - hidden tabs unhide / hide automatically.

    Thank you Leo.

    I have downloaded the link but macro is not working. I can manually unhide a sheet which then auto hides after selecting on another sheet. Unfortunately, the hyperlinks are not opening (auto unhiding the desired sheet).

    Thanks again for your help.

    Jonathan =]
    Reply With QuoteRegister To Reply
  8. 10-31-2016, 02:28 AM #8
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Hyperlinking to hidden tabs - hidden tabs unhide / hide automatically.

    to go to desired sheet just select in column B

    did yoy try ?
    Reply With QuoteRegister To Reply
  9. 10-31-2016, 02:42 AM #9
    jexcelio
    jexcelio is offline
    Registered User
    Join Date
    10-30-2016
    Location
    Doha
    MS-Off Ver
    2010
    Posts
    8

    Re: Hyperlinking to hidden tabs - hidden tabs unhide / hide automatically.

    It works. I was excited an must have overlooked your comment on column B. Thank you so much Leo.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cant unhide hidden tabs
    By Naz555 in forum Excel General
    Replies: 3
    Last Post: 10-08-2015, 08:26 PM
  2. [SOLVED] Format all cells in all sheets to Protection Hidden on visible and hidden tabs
    By DeRo22 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-28-2014, 03:17 PM
  3. [SOLVED] trying to access the excel sheets/Tabs in the hidden/very hidden mode through hyperlinks
    By Kiran Kurapati in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-30-2013, 06:50 AM
  4. [SOLVED] Hyperlink to Hidden tabs then hide again after completed data input.
    By Toli in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 08-22-2012, 07:31 PM
  5. Assigning Object a Macro to unhide hidden tabs with specific text
    By alorro3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2012, 12:26 PM
  6. Using checkboxes on summary sheet to name tabs and hide/unhide tabs
    By eew2201 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2012, 06:13 PM
  7. How can I find/unhide hidden excel sheet tabs on a worksheet?
    By magician in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-13-2012, 05:37 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1