Good afternoon,

I currently have an excel workbook in which I regularly launch a very
long macro M1 (about 15 mn).
To sum things up, my workbook is made up of 2 sheets:
- one sheet on which I am always working, and where real-time data is
updated
- one data sheet.

The M1 macro does a refresh of my data sheet. While M1 is running, my
main sheet is not available anymore.. I have to wait for the end fo
this update to work again.  .

I would like to launch M1 from my workbook in a new excel application
so as to continue working on my current sheet, and import the data when
it's over.

M1 can be launched (from a toolbar that I created) by different users
at the same time, but I can allow only one M1 to run at a time. I
therefore need to be able to specify to the user that M1 is already
launched.

I don't really know what I will be able, but I would really appreciate
any help you might give me.

Thank You