View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tkt_tang@hotmail.com is offline
external usenet poster
 
Posts: 92
Default 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.