Using worksheet_change
 

I have successfuly implemented worksheet_change to perform some actions
(clearcontents on various ranges) on the worksheet in question.

However, when I attempted to perform the same actions in ANOTHER worksheet,
based on the same event, the code halted.

I suspect that worksheet_change can't launch actions in other sheets, but I
am not sure. In the end, I am trying to find a way to launch actions on this
other worksheet...biggest barrier is that nothing changes on that other
worksheet itself, all changes are the results of formulas linked to the
original cell that is changing.

For example...is there a workbook_change feature that would allow it? I
cannot find any syntax references anywheere...

Thanks for any help,
Tom

Using worksheet_change
 

In the thisworkbook module:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

End Sub


--
Regards,
Tom Ogilvy


"Tom Mackay" wrote:

I have successfuly implemented worksheet_change to perform some actions
(clearcontents on various ranges) on the worksheet in question.

However, when I attempted to perform the same actions in ANOTHER worksheet,
based on the same event, the code halted.

I suspect that worksheet_change can't launch actions in other sheets, but I
am not sure. In the end, I am trying to find a way to launch actions on this
other worksheet...biggest barrier is that nothing changes on that other
worksheet itself, all changes are the results of formulas linked to the
original cell that is changing.

For example...is there a workbook_change feature that would allow it? I
cannot find any syntax references anywheere...

Thanks for any help,
Tom

Using worksheet_change
 

Worked perfectly...thanks for the assistance, this site is so helpful to
non-programmers lime me trying to get by.

"Tom Ogilvy" wrote:

In the thisworkbook module:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

End Sub


--
Regards,
Tom Ogilvy


"Tom Mackay" wrote:

I have successfuly implemented worksheet_change to perform some actions
(clearcontents on various ranges) on the worksheet in question.

However, when I attempted to perform the same actions in ANOTHER worksheet,
based on the same event, the code halted.

I suspect that worksheet_change can't launch actions in other sheets, but I
am not sure. In the end, I am trying to find a way to launch actions on this
other worksheet...biggest barrier is that nothing changes on that other
worksheet itself, all changes are the results of formulas linked to the
original cell that is changing.

For example...is there a workbook_change feature that would allow it? I
cannot find any syntax references anywheere...

Thanks for any help,
Tom