copying macros

L

Louise

Hi all
A colleague of mine wants to create several macros that the whole team can
use. He intends to put these macros onto a drive that we can all gain access
to so we can open the workbooks.

Once the workbooks are on the shared drive, how do we copy them into the
relevant workbooks on our own PC's?

Thank you.
Louise
 
B

BetterSolutions.com

Hi Louise,

If different users want to share some macros then I would suggest creating
an Excel add-in and putting that add-in on to a shared drive.

That way each of you can load the add-in to get access to the macros.

Let me know if you need any help creating an Excel add-in.

regards
 
L

Louise

hello, thank you for your reply.

Oh dear, this sounds rather complicated........

No idea how to use add-ins i'm afraid.

Louise
 
Top