Visible automated Excel: automation crashes if user selects cells, protection?
 

I'm trying to get real-time interaction between excel and other
programs.

with automation I can send and retrieve values from/to other
applications,
but as soon as the user selects excel, the automation crashes.

Are there ways to

a) protect the excel window from crashing,
e.g. by hindering the user to get focus on it or

b) have automation and the user interfering at the same time? (would be
ideal)

thanks in advance!

Visible automated Excel: automation crashes if user selects cells, protection?
 

Christian,
There are some Application setting that may help:
..Interactive
..IgnoreRemoteRequests

But if the user cannot interact with this instance, why not just make your
instance .Visible=False ?

NickHK

"Christian Friedrich" wrote in message
ups.com...
I'm trying to get real-time interaction between excel and other
programs.

with automation I can send and retrieve values from/to other
applications,
but as soon as the user selects excel, the automation crashes.

Are there ways to

a) protect the excel window from crashing,
e.g. by hindering the user to get focus on it or

b) have automation and the user interfering at the same time? (would be
ideal)

thanks in advance!