+ Reply to Thread
Results 1 to 3 of 3

Hyperlink for hidden sheets

  1. #1
    Registered User
    Join Date
    10-20-2010
    Location
    Italy
    MS-Off Ver
    Excel 2003
    Posts
    30

    Hyperlink for hidden sheets

    Hello, I'm trying to figure out how to make -not visible- hidden sheets but make the hyperlinks accessible to those of them who are linked

    In particular as per the attached doc, the active hyperlink referencing to the hidden sheet does not work

    Let me add that in the hidden sheet there is also a "return" button to return to the starting form, I do not know if this element requires an additional step

    Please Login or Register  to view this content.


    P.S. I found this code on the web but I don't know how to change it hence I can not make it usable for me
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    575

    Re: Hyperlink for hidden sheets

    You really don't need all that.

    In the worksheet selection change event put

    Please Login or Register  to view this content.
    and in the code for your 'back' button add

    Please Login or Register  to view this content.

    In other words, you only care about where the user has clicked, not what's in the cell.

  3. #3
    Registered User
    Join Date
    10-20-2010
    Location
    Italy
    MS-Off Ver
    Excel 2003
    Posts
    30

    Re: Hyperlink for hidden sheets

    Hi and thanks for quick answer

    I've applied for requested topics but it seems something is not working.
    Attached Files Attached Files

+ 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 to Hidden Sheets
    By JasonNeedsHelp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2016, 03:45 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. Replies: 1
    Last Post: 02-23-2013, 05:18 AM
  5. Hyperlink with Hidden Sheet
    By niladri20005 in forum Excel General
    Replies: 0
    Last Post: 10-21-2011, 01:10 PM
  6. Hyperlink Issues going to hidden sheets
    By Thelt2000x in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2011, 01:45 PM
  7. [SOLVED] Hyperlink to hidden worksheet
    By JoeleneW in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-11-2006, 06:20 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