run excel macros from shared drive
 

Hello,

Is there a way I can run an Excel Macro from a shared drive location on to
another Excel Workbook? I don't want to save the Excel Workbook with all the
macros to the users' Excel Startup folder if I can help it.

run excel macros from shared drive
 

Macros live in workbooks. So put the workbook with the macro in that shared
drive location.

I'd mark the file as ReadOnly so that multiple users can open that file at the
same time.



dimpie wrote:

Hello,

Is there a way I can run an Excel Macro from a shared drive location on to
another Excel Workbook? I don't want to save the Excel Workbook with all the
macros to the users' Excel Startup folder if I can help it.

--

Dave Peterson