+ Reply to Thread
Results 1 to 10 of 10

VBA for Hyperlinks to Hidden Worksheets

  1. #1
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 365
    Posts
    164

    VBA for Hyperlinks to Hidden Worksheets

    Hello, I need some help to see if I can do what I am proposing with hyperlinks and hidden worksheets. I am attaching a sample spreadsheet with the following information:

    A home worksheet with icons
    Three hidden worksheets that relate to each of the icons on the home worksheets

    I would like to keep the three hidden worksheets hidden, but when you click on the picture(icon) on the home worksheet, that click takes you to the hidden worksheet and does NOT unhide it.
    On the hidden worksheets there is a link to take the user to the home worksheet.

    This spreadsheet is much larger with more icons on the home page and more hidden worksheets, but I am thinking if this is doable and I can figure out the VBA part, then I should be able to move forward with just a little bit of help. If there is a different solution, it would be helpful if you would share this as well.

    Thank you

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: VBA for Hyperlinks to Hidden Worksheets

    I don't understand what you are trying to do. You can operate on elements ... cells, ranges, objects, etc., in a hidden worksheet but AFAIK, you can't follow links on it. Not sure how you would/could do that.

    Using VBA you could assign a macro to each picture that unhides the relevant sheet and hides the HOME sheet. Similarly, assign macros to the pictures on those sheets to hide the sheet and unhide the HOME sheet.

    Other than that, I don't think you can do what you describe ... you can't click on a link on a sheet that is hidden.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    05-12-2018
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    266

    Re: VBA for Hyperlinks to Hidden Worksheets

    this helps?

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: VBA for Hyperlinks to Hidden Worksheets

    This is what I had in mind which is similar to the solution in Post #3

  5. #5
    Forum Contributor
    Join Date
    05-12-2018
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    266

    Re: VBA for Hyperlinks to Hidden Worksheets

    @ TMS

    It's better! Hidding the sheet as soon as it's selected !

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: VBA for Hyperlinks to Hidden Worksheets

    @SjonR: thanks Thanks for the rep

  7. #7
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 365
    Posts
    164

    Re: VBA for Hyperlinks to Hidden Worksheets

    I am able to click to go to the worksheet from the home worksheet, but now I cannot go back to the home worksheet by clicking "Go Back to HOME."

    I wonder if there is a dashboard type of functionality in Excel that I should be using.

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: VBA for Hyperlinks to Hidden Worksheets

    OK, we can add some Workbook Event handlers ... see the attached

    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 365
    Posts
    164

    Re: VBA for Hyperlinks to Hidden Worksheets

    I think this may work! I am going to add the VBA to my spreadsheet and see how it does. Thank you for your tenacity and for your help!

  10. #10
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: VBA for Hyperlinks to Hidden Worksheets

    You're welcome.

+ 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. Hyperlinks with hidden worksheets
    By MPB in forum Excel General
    Replies: 8
    Last Post: 04-11-2021, 02:47 PM
  2. [SOLVED] VBA for Ctrl+Home for all worksheets including hidden and Very hidden
    By Neilesh Kumar in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-17-2018, 08:28 AM
  3. Replies: 0
    Last Post: 04-13-2018, 01:18 PM
  4. [SOLVED] Hyperlinks to Hidden Worksheets
    By Jamidd1 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-21-2016, 02:06 AM
  5. [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
  6. Hyperlinks with hidden sheets
    By jespvik in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2013, 07:26 PM
  7. Replies: 3
    Last Post: 08-08-2006, 08:10 AM

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