View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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