Hi Shaka215;
You can use the Application.Interactive property

MP

a écrit dans le message de news:
...
This is a rather different question then what's normally asked on
these boards... I need some advice regarding API commands and personal
liability...I work for a company that will go unnamed in this message.
I have been proposing a method using Excel / VBA to speed up a process
up that currently takes way to freaking long to do with the company I
work for. My boss has agreed for the production of this new custom
designed software and has supported it from day one... I have figured
out how to get the process much faster using VBA and Excel...The
method we use now is semi-flawless, unless its 'fat fingered' or the
normal human mistakes, because its done by hand. My new method which
could do 1000 updates in less then 5 minutes versus a 1000 updates
taking about three weeks to complete...errors can still happen with
entering the information on my application but its unlikely it could
happen. However there is a problem... In order for my process to work
correctly and completely I require that the end-user does not
interrupt the process as it could effect millions of dollars worth of
inventory as Excel is altering information inside of another system in
real time... (Please do not ask how I managed to get this to work as I
will not share the code; as its corporate property not mine), so I
have decided to use an API command to shut off the keyboard and mouse
during the update process. Now I could display a message saying
"Please do not interrupt this process!" but I need the comfort of
being able to sleep at night knowing that a end-user in my department
won't crash the system by stopping my application prematurely because
they want to check their e-mail...which is why I have decided to
include this API command in the applications process to kill the
keyboard and mouse until the macro is over with.

My question is how would you go about recommending the
'enhancement' (API command to kill keyboard and mouse temporarily) in
a business when it could be looked at through a different light as a
malicious piece of code (virus)? This enhancement makes sense to me,
as the developer and team leader of the department, but I don't know
how it would look to the IT department (security) inside of the
company...any suggestions?