Application.Calculation gives run time error
And thanks for posting back with your results.
Martien Janssen wrote:
Dear Peter and Dave,
Many thanks for your reply. Indeed, setting .takefocusonclick to false did
the job. I would never have found that one myself.
Many thanks again,
Regards,
Martien
"Peter T" <peter_t@discussions wrote in message
...
Hi Dave,
I didn't see yours when I sent mine. You asked the OP -
Could you post back your results (I'm kind of curious).
In my XL97 I replicated the OP's error. Changing .takefocusonclick to
false
fixed it
Regards,
Peter T
--
Dave Peterson
|