View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Beto[_3_] Beto[_3_] is offline
external usenet poster
 
Posts: 140
Default 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