customizing debug pop up window
 

Hi

If a user decides to hit the esc key right in the middle of one of my
procedures (bug free, etc), this will leave the file in an odd state.
The file is set up so if the routine is re-run it cleans the file up
and restores it to proper form.

But hitting esc exposes my code which is password protected when the
file is idle. I employ a little trick that makes it impossible to hack
into my worksheet code, but the achilles heel is the esc button.

What I want is to have the file close if the routine is stopped in mid
stream. This way the code is not exposed, and the user cannot monkey
with the file.

I guess i am refering to the debug window. I wanted to set the file up
where i have a custom debug window that when a button is pressd the
file closes OR when the user escapes out of the window the file closes
as well.

Any thoghts on this would be greatly appreciated!

thanks

tx


--
tx12345
------------------------------------------------------------------------
tx12345's Profile: http://www.excelforum.com/member.php...o&userid=24776
View this thread: http://www.excelforum.com/showthread...hreadid=574422