User-Function Auto Activation

[N1GHTEYES]

I think I remember reading that it was possible to programatically ensure that a user-function is called whenever the spreadsheet on which it is used changes (as per inbuilt functions). Unfortunately, I can't remember how.

Does anybody want to give me a clue?

 

[Fr33dan]

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    ' Call or Write Method here
End Sub

This will run whenever a worksheet changes but I'm not sure if there is a sub that covers the entire workbook.

 

[PHV]

You meant the Application.Volatile method ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[N1GHTEYES]

PHV - Ta. That's EXACTLY what I meant.