Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: link to hidden sheets

  1. #1
    Join Date
    5th October 2005
    Posts
    18

    link to hidden sheets

    I am wondering how to link from one cell to a cell in a hidden sheet in the same excel file.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    15th April 2003
    Location
    USA
    Posts
    7,422

    Re: link to hidden sheets

    Links to hidden sheets work the same as any other sheet. It would probably be easier to unhide the sheet, create the links, then hide it again. But you can also just type the references to the hidden sheet. For example:
    =SUM(HiddenSheetName!A2:A300)
    Please do not U2U (private message) me directly for questions that should be posted to the forum; any such U2Us will be ignored.

  3. #3
    Join Date
    5th October 2005
    Posts
    18

    Re: link to hidden sheets

    when I create the link then hide the sheet it, the link does not do anything. And i'm not trying to use the data for a formula i'm just trying to go to that cell when it is on the sheet that is hidden.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    14th July 2004
    Posts
    10,539

    Re: link to hidden sheets

    By link, do you mean hyperlink?

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    5th October 2005
    Posts
    18

    Re: link to hidden sheets

    yes I do mean hyperlink.

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    14th July 2004
    Posts
    10,539

    Re: link to hidden sheets

    Well the only way I can think of to get your hyperlink to work would be to use code with the FollowHyperlink worksheet event to unhide the sheet.
    VB:
    Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) 
        Dim strRng 
        strRng = Target.SubAddress 
        Sheets(Left(strRng, InStr(strRng, "!") - 1)).Visible = True 
    End Sub 
    
    

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Print Some Hidden Sheets
    By Horpe in forum EXCEL HELP
    Replies: 2
    Last Post: January 15th, 2008, 01:51
  2. VBA With Hidden Sheets
    By kwidlake in forum EXCEL HELP
    Replies: 3
    Last Post: December 6th, 2007, 12:26
  3. Working Cell Link To Hidden Work Sheet?
    By financialhost in forum EXCEL HELP
    Replies: 1
    Last Post: January 30th, 2007, 01:45
  4. Printing Hidden Sheets
    By Cabbage88 in forum EXCEL HELP
    Replies: 4
    Last Post: July 30th, 2005, 02:04
  5. Hidden Sheets
    By Wistow in forum EXCEL HELP
    Replies: 7
    Last Post: February 27th, 2003, 05:39

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
  •  
porno