Class module to detect row deletion or insertion ?

[brettdj]

I read a query where a user wanted to monitor row deletion or
insertion on a master template sheet. This change would then be
propogated throughout all the other worksheets in the active workbook

I was wondering if a class module could be used to handle this -
before I went spend time on it I'd appreciate and advice on the
viability of this approach

Regards

Dave

 

[Tom Ogilvy]

Something would have to trigger the firing of code associated with the class
module. The problem is that there is no direct unique event associated with
this. If in previous postings, someone suggested some generic events that
would fire in this situation, then you could tie to those events and have
your class module provide some scheme for identifying that a row has been
deleted. Other than that, I don't see that a class module would add any
expanded ability to detect this.