At first let me say that I am simply terrified that you are using
MS-Excel and VBA to work on a project so sensitive. That makes me shake in my
skin.
OK so be the case your solution could be something like that:
1) Supervisor working.
2) Supervisor gets interrupted.
3) Supervisor hits the panic button
4) Code behind the button executes.
4a) In a special area, a worksheet in a workbook or an external text file, you
will save the information necessary to locate the call the supervisor was
working on in step 1. Say if the calls are in a worksheets and they are in rows,
and the supervisor is on row 17 on call number 5, then the code for 4a will save
the worksheet name and 17.
4b) When the supervisor returns to work and he/she activates MS-Excel and the
workbook application is launched the code will look at that special area and see
where the supervisor needs to be placed, worksheet name, and row 17 in the above
example, and you are done.
4c) The code will empty the special location, so that the fact that it is not
empty is indicative of an interruption vs. the supervisor leaving for the day,
or finishing the work. So the special area is populated ONLY in the case of
pressing the panic button, ergo being interrupted.
So I hope this is a starting point for you. My advaice is that you can actually
hide the MS-Excel window, vs closing and exiting MS-Excel. Look at the MSKB
http://support.microsoft.com/search/ for help.
Also you could display a Userform with a login and password that is only known
to the supervisor.
As to how to handle multiple supervisors, that depends on answers to these
questions:
1) Will supervisor 1 continue from where supervisor 1 finished, or from where
the panic button was pressed. That is if supervisors 1 and 2 are working, and S1
is interrupted, but S2 is still working then S2 gets interrupted will S1
continue from S1 position or S2 position?
2) Is this a shared workbook or each supervisor has his or her workbook?
This is why a password log in userform is so nice, it locks the workbook as is.
OK these re ideas, so you can start, if you need any extra help, call again.