Button Click Problem

[JohnDonaldson]

I have a routine that when the user clicks on a button the first thing that it does is look to see if a certain data file is open and if it is delete it, then do some setup code, then open the data file again, put data into it and then exit the routine. I have found that if the user raplidly clicks the button that once in a while a RUN TIME error is generated. I have traced this down to what I think is that XP is trying to delete and open the same data file at the same time. I belive that if the user clicks on the button fast enough that multi-instances of the routine are started that can cause the conflit.

Is there a way that once the user enters the routine, that I can lock the routine from triggering agian until I am finished with the routine?

I have a similar problem with a routine that is called when the user clicks on an thumbnail. Here the routine sets up and displays the associated image file. Again if the user rapidly clicks on various thumbnails, I think once in a while two instances get started and XP can not load two image files at the same time and again a RUN TIME error is generated.