hyperlink to a hidden sheet!

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Hi all,

i have a query , i maintain a workbook to which i add a worksheet everyday.
By the end of month, it has 30 odd sheets to work on which makes it look
tedious. All the sheets are named datewise.

So in Sep i have a file that contains 30 sheets starting from Sep 1 to Sep
30.

Now what i am trying to do is , if possible, after all 30 sheets are
included ; i plan to ut in a new sheet right which shall contains dates in a
column.
Lets say the cell which contains Sep 1 if someone clicks on tht he is
transfered onto SEP 01 sheet.

Thats easy and done but if i hide sheet namely SEP 01, the link doesn't seem
to function!

Does Hyperlink work to hidden sheet or am i out of Luck

Any help appreciated!
Jim
 
Hi
AFAIK you can't link to a hidden sheet. What would you expect to see as
this sheet is hidden :-)
 
You could replace your hyperlinks with a little worksheet event.

I put the worksheet names (no addresses) in column A.

Right click on the worksheet tab that holds these names.
select view code and paste this in:

Option Explicit
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _
Cancel As Boolean)

Dim testWks As Worksheet

If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Target, Me.Range("a:a")) Is Nothing Then Exit Sub

Set testWks = Nothing
On Error Resume Next
Set testWks = Me.Parent.Worksheets(Target.Value)
On Error GoTo 0

If testWks Is Nothing Then
'not a "link"
Else
testWks.Visible = xlSheetVisible
Application.Goto testWks.Range("a1"), scroll:=True
Cancel = True 'stop from editing in the cell
End If

End Sub

Then back to excel and double click on the cell to see if it works.
 
Back
Top