Hi
I have a Worksheet_Change event on Sheet 1. I have some cells linked from
Sheet 1 to Sheet 2. I also have a Worksheet_Change event on Sheet 2.
When I add information on Sheet 1 the cells update on sheet 2 but the
Worksheet_Change event for sheet 2 does not run.
(I hope you are following this!)
Is there any way that the Worksheet_Change (on Sheet 2) can be made to run
when the linked cells are changed on sheet 1?
Sandy

Worksheet_Change events only fire when an entry is made on the active sheet.
Nothing happens when a calculated value changes on a sheet that is not
active. For example, if you make a change on sheet 1 that changes a
calculation in sheet2, the worksheet change event for sheet 1 only will run.
If you want something to happen to sheet 2 when you change something on
Sheet1, you'll need to add it to you SHeet1 code.

"Sandy" wrote:

Hi
I have a Worksheet_Change event on Sheet 1. I have some cells linked from
Sheet 1 to Sheet 2. I also have a Worksheet_Change event on Sheet 2.
When I add information on Sheet 1 the cells update on sheet 2 but the
Worksheet_Change event for sheet 2 does not run.
(I hope you are following this!)
Is there any way that the Worksheet_Change (on Sheet 2) can be made to run
when the linked cells are changed on sheet 1?
Sandy