Application.Interactive and Uninterrupted VBA code

[tmktech]

I am not having success with "Application.Interactive = False" as a means to prevent Excel VBA code from being interrupted by the user (i.e. {ESC}) . I've also used the .Onkey method to set the {ESC} key procedure to null.

This occurs in both 2000 and XP.

I have looked for other actions which may be implicitly resetting the .Interactive method back to true, but have not identified any.

Is there a (better) way to acheive this?

Thanks in advance for any help!

 

[tmktech]

Hey all. I got my answer i a reply to another thread. Thans Mike and Justin!

TMK