Thread: Control & Break
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Control & Break

I am not absolutly sure but I think Control+Break is hard
coded in stone. It's the programers panic button.
-----Original Message-----
I have a problem with 1 or 2 "super" users.

Occasionally they will press the Ctrl+Break keys because
they can't be bothered to make a couple of simple
selections (which only takes3 to 4 seconds anyway).

As a result, the information they supply can be incorrect
because they may have entered data against a cost centre
that is not valid for their entity (I can't validate

their
data as it has to be free form entry).

Is there a way that I can stop Control & Break from
stopping the execution of my code during the Auto_open
procedure ?

Also, I want to make sure that it is re-enabled when the
Auto_open procedure has completed.

Many Thanks
Alan
.