How can I automatically execute a macro if there a 1 or -1 in a cell

[arrautxa]

I have the following problem.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I do have a worksheet where I have several functions. One of those sub is as follows:<o></o>
<o></o>
Private Sub Worksheet_Change(ByVal Target As Excel.Range)<o></o>
If Target.Column = 1 Then
If Target.Row = 6 Then
If Target.Value = 1 Then
'Call macro here
End If
End If
End If<o></o>
<o></o>
if I place manually 1 in cell A,6 and manually click enter, it will call the macro with no problem.<o></o>
What I need help with is that I am planning to place a 1 or -1 on that cell automatically which is sent by another macro but I need help is to check if the is a 1 with the private sub above and need to perform the click automatically without my intervention. Once the macro is confirmed to be executed I would like to blank that cell in order to wait for the next instruction.
A,6 will not be the only cell that will have to check for a 1 but the check will always be on column A.
Can anybody help me with this macro.
Best Regards
Bill

 

[Andrew Poulsom]

Re: how can I trigger a macro when a range of cells in workbook XX are link to range of cells in another workbook YY

You need to disable events to prevent the loop.

 

[arrautxa]

I have done what you said and it did'nt work. Any other suggestion?
Many Thanks in advance.
Bill