Excel Links for today

  • Buffer
  • Sharebar
  • Buffer
jethro's picture

Dick Kusleika writes:

The Excel object model provides the Application.CalculationInterruptKey property to control how/if calculation can be interrupted. xlAnyKey is the default and it pauses whenever the user starts working. xlEscKey only pauses when the escape key is pressed. It’s used when you want to allow the user to interrupt calculation, but you want to make sure they do it explicitly and not by accident. xlNoKey prevents interruption. It seems that any time you calculate in code, you should set this property to xlNoKey, then set it back.

Full article here

My stats for June. Not quite as good as J-Walks – though my bounce rate is better!

image

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Anonymous's picture

Bien interesante!!!

Bien interesante!!!