Nigel, Esq.,
Thank you for responding to my query.
By virtue of,
Application.EnableEvents = False ;
And therafter, everything else will be Dormant and remain so ......
that's Not a State Everybody Else would be yearning to enter.
Besides UnDo, Autofit-button will also activate Private Sub
Worksheet_Calculate() ; so do many more other buttons, I reckon.
Private Sub Worksheet_Calculate(), in this particular instance, is
deployed in waiting for "ActiveSheet.AutoFilter" actuation alone.
Meaning that it would be meaningless to activate,
Private Sub Worksheet_Calculate(), if UnDo-button is inadvertently
pressed.
It will only be meaningful to activate, Private Sub Worksheet_Calculate
(), when the AutoFilter on th e ActiveSheet is effected thereof.
Admittedly, Private Sub Worksheet_Calculate() is particularly
unruly ;
When one Private Sub Worksheet_Calculate() executes, it appears that
all the other Private Sub Worksheet_Calculate()'s coded behind all the
other worksheets would execute too.
There's no stopping all the Private Sub Worksheet_Calculate()'s from
executing All-At-Once (although it may not mean Simultaneity in the
Relativistic-Sense).
Regards.