Re : Excel to by-pass Private Sub Worksheet_Calculate()

T

tkt_tang

To click the UnDo-button and then, Private Sub Worksheet_Calculate()
inadvertently executes.

Would like to by-pass the given Event-Handler, but How ?

Please share your experience. Regards.
 
T

tkt_tang

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.
 
T

tkt_tang

Nigel, Esq.,

Thank you for responding to my query.

As given previously,

Private Sub Worksheet_Calculate(), in this particular instance, is
deployed in waiting for "ActiveSheet.AutoFilter" actuation alone.

The question is, to devise a certain means,
to isolate, Private Sub Worksheet_Calculate(), such that it would not
respond to extraneous activation by, Autofit, UnDo, ReDo and probably
a multiplicity of other (spurious) button-clicking.

Private Sub Worksheet_Calculate(),
is meant for "ActiveSheet.AutoFilter",
out of exclusive necessity in this application.

Please share your experience. Regards.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass variables from Worksheet_Calculate sub to Module 2
worksheet_calculate 2
Re : Excel FilterMode to Trigger WorkSheet_Calculate() 3
Nesting worksheet_Calculate inside worksheet_CHANGE 5
Worksheet_Calculate problem 5
Worksheet_change or Worksheet_calculate 2
Handling a worksheet calculate event in XLA code 4
Problem with the code, probably with Private Sub Worksheet_Calculate() 4

Top