Need macro help restricting when it is executed

You need to make a Worksheet_Change macro on each sheet, with the range on _that sheet_ in it.
You can't use "Worksheet_Change" with a range on another worksheet, sorry.

Originally Posted by JasperD

You need to make a Worksheet_Change macro on each sheet, with the range on _that sheet_ in it.
You can't use "Worksheet_Change" with a range on another worksheet, sorry.

To save putting the same macros in every single worksheet though, i put them all in a module, and then fired the module by putting the workbook_sheetchange macro in the workbook section.

Is there no way something can be written into the workbook macro rather than to put a set of macros on every worksheet (of which they are about 30)

Thanks