Excel hyperlink to a named range

[mcwilson]

Hello all-

I have a list of dates in column A. In column B, i display the month name (=month(A1)). In the same workbook i have a calendar displaying each month. Each month's calendar has a section that is named. January is "January", February is "February", etc.
I want a user to be able to put in a date in column A, then have a hyperlink in column C that will take them to the specific month's calendar.
I.E. if A1 is 2/1/11, I have B1 read "February", and I want C1 to have a hyperlink to February. But C1 needs to go to a different month if A1 is changed....


Ideas?

Thanks in advance!

 

[mowgli212001]

Instead of having a hyperlink, why not use the selection change event when cell C1 is selected to goto the named reference that is in cell B1

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
 If Target.Address = "$C$1" Then
  Application.Goto Reference:=Range("B1").Text
 End If
End Sub

 

[mcwilson]

If possbile, i would like to use a formula as i have to do this throughout the entire worksheet and workbooks...i do not want to keep altering the code as this could get messy

 

[mowgli212001]

you could try playing around with this

=HYPERLINK("[WorkbookName.xls]SheetName!"&TEXT(B1,"mmmm"), TEXT(B1,"mmmm"))