run excel macros from shared drive

G

Guest

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.
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel is removing Macros from workbook 3
How to Unlock Excel Workbook protected by MACRO Password 6
Unwanted workbooks on startup 2
Run Macro If Cell have "x" value 0
How to call Excel add-in macro from a button… 1
Macro not always when opened from shared drive 3
Why does excel sometimes not ask to enable macros (medium security 1
Private Macros 3

Top