Need help on continuous running of a macro

[cushal]

Hello all,

I have an elementary level macro which basically opens a hyperlink when the number in a cell changes. The problem for me is though that I cant get the macro to be running continuously and it gets executed only when I run it myself each and every time. I basically need for the macro to be constantly on and execute the hyperlink each time the cell value changes. I looked up on the internet and it asked me to access the private Worksheet object and put in the code in Private Sub Worksheet_Change(ByVal Target As Range). How exactly do I access this object? Any help would be greatly appreciated.

 

[Sal Paradise]

Right-click the sheet name, go to view code.

Inside the following tags, put your code:

Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

Note that whatever cell(s) was (were) changed are 'Target'. If you only want to, for instance, have your macro activate when Cell A1 is changed, you can add the following around your code:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target,Range("A1")) Is Nothing Then
        'Insert Macro Here
    End If
End Sub