hyperlink question

There is a way to run macros from Hyperlinks is this what you are asking to do because, I am not sure about your question about new windows, if this is what you want then,here is a code for that


Hit Ctrl k to get to hyperlinks
in text to display enter Macro1
in cell reference enter a cell reference
repeat

This goes in the worksheet module

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    Select Case Target.TextToDisplay
    Case "Macro1"
        Macro1
    Case "Macro2"
        Macro2
    Case "Macro3"
        Macro3
    Case "Macro4"
        Macro4
    End Select
End Sub

This goes into a regular module

Sub Macro1()
    MsgBox "Macro1"
End Sub
Sub Macro2()
    MsgBox "Macro2"
End Sub
Sub Macro3()
    MsgBox "Macro3"
End Sub
Sub Macro4()
    MsgBox "Macro4"
End Sub