+ Reply to Thread
Results 1 to 3 of 3

Show hidden tabs after clicking link to those tabs

  1. #1
    Registered User
    Join Date
    10-23-2018
    Location
    SW Florida
    MS-Off Ver
    Office 365
    Posts
    17

    Show hidden tabs after clicking link to those tabs

    Please help me with a code in order to get to hidden worksheet tabs when clicking on a link.

    Specifically, I want to be able to hide all of the RCO # tabs and when I click on the link on the Change Orders table in column L on the Estimate Overview Sheet the link will navigate to the corresponding hidden sheet.
    Please see attached.

    Thank you for your time
    Attached Files Attached Files
    Last edited by Pepe Le Mokko; 04-09-2020 at 11:00 AM. Reason: Title - We know you are looking for help

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Show hidden tabs after clicking link to those tabs

    I've done in a bit different way. Instead of link I've used doubleclick on cell.

    Into all RCO sheets vba code put:
    Please Login or Register  to view this content.
    and into EstimateOverview (I understand that we are talking about this col. L) put:

    Please Login or Register  to view this content.
    Check attached file.
    Attached Files Attached Files
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    10-23-2018
    Location
    SW Florida
    MS-Off Ver
    Office 365
    Posts
    17

    Re: Show hidden tabs after clicking link to those tabs

    Thank you so much

+ 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. Replies: 3
    Last Post: 09-28-2017, 07:08 PM
  2. Hyperlinking to hidden tabs - hidden tabs unhide / hide automatically.
    By jexcelio in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-31-2016, 02:42 AM
  3. Replies: 1
    Last Post: 05-18-2014, 02:12 PM
  4. [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
  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. Copy pie chart into new tabs, and show the results from data on those tabs
    By Sydney Lee in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-23-2012, 07:50 PM
  7. [SOLVED] my tabs are hidden and can't make them show
    By Wendy in forum Excel General
    Replies: 2
    Last Post: 07-19-2005, 02:05 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