copying macros

[Guest]

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

 

[Guest]

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

 

[Guest]

hello, thank you for your reply.

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

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

Louise