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?