Change in one Worksheet Activates Another Worksheet Change
 

Hello:

I have a series of macros in Sheet12 - Sheet24, which each contain
Worksheet_Change macros. I would like to set up a Macro so that when a
new worksheet (Sheet6) is updated with data, it runs the macros in
Sheets 12-24.

Can someone please help with this?

Many thanks,
Ebachenh


--
ebachenh
------------------------------------------------------------------------
ebachenh's Profile: http://www.excelforum.com/member.php...o&userid=32370
View this thread: http://www.excelforum.com/showthread...hreadid=522251

Change in one Worksheet Activates Another Worksheet Change
 

You're probably better off using the Workbook_SheetChange
procedure in the ThisWorkbook code module rather than the
Worksheet_Change event in each worksheet.


"ebachenh"
wrote in
message
...

Hello:

I have a series of macros in Sheet12 - Sheet24, which each
contain
Worksheet_Change macros. I would like to set up a Macro so
that when a
new worksheet (Sheet6) is updated with data, it runs the macros
in
Sheets 12-24.

Can someone please help with this?

Many thanks,
Ebachenh


--
ebachenh
------------------------------------------------------------------------
ebachenh's Profile:
http://www.excelforum.com/member.php...o&userid=32370
View this thread:
http://www.excelforum.com/showthread...hreadid=522251

Change in one Worksheet Activates Another Worksheet Change
 

Would you be able to help with the code syntax? I'm a real newbie.

Thanks,
Ebachenh


--
ebachenh
------------------------------------------------------------------------
ebachenh's Profile: http://www.excelforum.com/member.php...o&userid=32370
View this thread: http://www.excelforum.com/showthread...hreadid=522251