running macro/user form from other excel files
I have few questions on this macro, that I have written that provides forms for data entry and processes batch, which will be used by multiple users at the same time.
1, Is it possible to allow the user to access this macro at the same time? If not, any recommendations as what I can do to allow the sharing access?
2. In this same workbook, I've also created a sheet consisted of reference data that I have assigned names and used by the macro which calls the user form that uses these name data. However, sometimes if I have other excel workbooks open and accidentally run the macro (using custom menu) with other workbooks active, the userform will open but cann't reference the data name I have linked them with. Is there a way I can reference these names in the macro so that macro can be executed successfully from any excel workbook, not just from the one contains the macro and user form?