Macro runs multiple times at once

[andyeastes]

Hello,

I have a macro that is being called by multiple users. It appears that it is allowing it to start a second instance before the first one completes. This is causing errors because one of the last steps is marking records as processed but if it gets started again before done it appends the already processed records again before they have a chance to get processed.

So, to fix this how can I make the macro wait until 'the first instance of the macro has finished before running again.2

Any thoughts or recommendations would be greatly appreciated!