You could put in

Application.Statusbar = "Macro running"

when you start running the macro. It will put a comment in the Lower LH
corner of the window. To turn if off use

Application.StatusBar = FALSE

HTH,
Barb Reinhardt

"RocketMan" wrote:

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?