T
tkt_tang
1. Enters an Excel worksheet (XL-2000).
2. Sheet1 incorporates an Autofilter (consisting of only one column
amidst several others).
3. While editing in a cell, Worksheet_Calculate() event handler would
be activated, followed suit by Worksheet_Change().
4. Have made use of Worksheet_Calculate() to handle Autofilter
tabulation events.
5. In this case, activation of Worksheet_Calculate() has indeed
interfered with the user operations.
6. It would have been more desirable to activate Worksheet_Change()
prior to Worksheet_Calculate().
7. Is there an alternative to sequence the activation of
Worksheet_Change() followed suit by Worksheet_Calculate() ?
8. Please share your experience.
9. Regards.
2. Sheet1 incorporates an Autofilter (consisting of only one column
amidst several others).
3. While editing in a cell, Worksheet_Calculate() event handler would
be activated, followed suit by Worksheet_Change().
4. Have made use of Worksheet_Calculate() to handle Autofilter
tabulation events.
5. In this case, activation of Worksheet_Calculate() has indeed
interfered with the user operations.
6. It would have been more desirable to activate Worksheet_Change()
prior to Worksheet_Calculate().
7. Is there an alternative to sequence the activation of
Worksheet_Change() followed suit by Worksheet_Calculate() ?
8. Please share your experience.
9. Regards.