I have the following macros set up in one worksheet "code-behind" page to call other macros when specific cells are changed:
---------------------------------------------------
Private Sub worksheet_change(ByVal Target As Range)
If Not Intersect(Target, Me.Range("B9")) Is Nothing Then Call...