View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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