Normally the only time someone could start your code a second time would be
if you have a modeless form showing and nothing else going on. Though in
long routines with DoEvents could allow the button to call your macro, or
some event triggered by your code in turn attempting to re-run your app.

You could set a global boolean flag and exit your code if it's true, and of
course set it false when all done.

Public gbAppRunning as Boolean

Regards,
Peter T

"RocketMan" wrote in message
ups.com...
I am required to have two different ways to activate the same macro:
from a button on a sheet and when the form is opened and a certain
field has 'auto' in it. I also realized that someone might just click
the button twice. I'd like to be able to check to see if a macro is
already working if the same macro is selected again.

How can I do this?