Re : Excel FilterMode to Trigger WorkSheet_Calculate()
Jacob Skaria, Esq
Thank you very much indeed.
Have used ActiveSheet for the "Code-Behind" of Sheet1 & Sheet2.
As it turns out, Sheet2 does not execute the on-board "Code-Behind's
Worksheet_Calculate()" ; it makes use of Sheet1's "Code-Behind".
That's rather Odd indeed.
Have not made use of WorkBook's SheetCalculate().
Other lessons learned are that WorkSheet_Calculate()'s could execute
one after the other for the WorkSheets' Code-Behind.
WorkSheet_Calculate()'s can be rather difficult to handle.
Please continue discussion.
Regards.
|