Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Class module to detect row deletion or insertion ?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Class module to detect row deletion or insertion ?
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. -- Regards, Tom Ogilvy "brettdj" wrote in message m... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating UDF by Class Module (Leo)? | Excel Discussion (Misc queries) | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
How to detect a col/row deletion? | Excel Programming | |||
please give an example of a class module. | Excel Programming | |||
how to declare a class module | Excel Programming |