HYPERLINK that points to same cell and runs macro?

[jmpatrick]

Good morning! I'm working on a formula that will create a hyperlink that points to the same cell in which it resides. Here's what I have:

=HYPERLINK("#Calendar!C7",AS7)

Calendar is the Sheet name, C7 is the cell the formula is in, and AS7 is the cell that provides the "friendly name."

In the Sheet's code is this:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)

    If Target.Range.Column = 3 Then Call OpenSearchEditFill
        
End Sub

I'm not getting an error, but Call OpenSearchEditFill isn't firing.

jp

 

[jmpatrick]

Also tried this:

=HYPERLINK(GZ7 & " - " &  "Calendar!C7",AS7)

...with this in GZ7:

file:///\\GLC-SERVER\Test\Test.xlsm

That throws a "can't open specified file" error.