Hi -

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?

Thanks.
Kathy

Kathy,

It's just to tell you that your question was interesting, I am surprized that so far no replies have come so far, I know that it's possible to invoke macros from one VBA project to another, you will have to write like this:
Workbooks("GMSFINANCE-TOOLBAR.xls").RunAutoMacros xlAutoOpen
or
Application.Run "'GMSFINANCE-TOOLBAR.xls'!PrintSetup"

For sharing thing I have yet to do R&D, will write once I succeed

Regards
Amjad Mahmood Email:amjad.s.mahmood@gsk.com

Hi,

Regarding accessing macros in one workbook from any other open workbook thru' a custom menu. It strikes me that your best option might be to convert the workbook containing the macro to an Add-In and then install the Add-In so that it loads any time Excel is opened. To convert to an Add-In you open the work book and do a Save As and change Save as Type to Microsoft Excel Add-In (*.xla). You then use Tools|Add-Ins... to install the Add-In so that it will be loaded whenever Excel opens. This should allow you unrestrained access to the Add-In from any workbook. Just ensure that in the Add-In macro code if you want to refer to something in the macro's own workbook access through the ThisWorkbook object and if you want to access something in any arbitrary active workbook use the ActiveWorkbook object.

Cheers
nic