More Then one Worksheet_Change
pauluk < wrote:
Is it possible to have two or more worksheet_change private subs running
on the same spreadsheet?
As I don't know the exact answer, I say try it and see what happens.
Otherwise, I see no need to have different subs if all the changes you
want to control can be controlled from this Event sub. If you don't want
to see a huge Worksheet_Change sub, then create other specific subs in
the sheet module and just call them from the Worksheet_change sub.
Regards,
--
Beto
|