Run Macro Or Hide Sheet Using Formula?

[t0ny84]

Hi,
I was wondering if anyone knows if it's possible and if so how to:

1) Run a macro using a formula in a cell?
2) Using Hyperlink to call macro?
3) Hide worksheet using formula?

Thanks in advance!

t0ny84

 

[JoeMo]

All good thanks so much for your help JoeMo. I was also wondering do you know of a way to use the FollowHyperlink VBA with a range of columns or cells?

It should work with the code below but do to it for each cell will get time consuming.

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    If Target.Range.Address = "$B$6" Then
        Call Macro1
        End If
         If Target.Range.Address = "$B$8" Then
        Call Macro2
         End If
End Sub

If each address calls a different macro I don't think there's any shortcut to specifying each address/macro combination.