hi,
we had the same problem once and solved it this way.
everyone created a personal workbook and put it in their xlstart folder on
their c drive. usually it is something like c:\program
files\msoffice\office\xlstart. it seems to vary depending on version. the
personal file is then hidden. on the public drive, we create a folder titled
bas.
macros were exported to the bas folder.
how?
in the vb editor (alt+F11), in the project widow(far lower left) click to
expand the project(file that has the macro). click to expand the project
modules then right click the maro and click export. browse to the bas folder,
name the macro then click save. the macro will export as a .bas file. you can
also export user forms(.frm).
this way users can import to their personal file only the macros they need
or want.
how?
in the vb editor (alt+F11), in the project widow(far lower left) right click
the personal project and click import. browse to the bas folder. click the
..bas file(macro) you wish to import and click open.

there are other ways to handle this. this was how we did it.

regards
FSt1

"Louise" wrote:

Dear all

I posted a question last week regarding copying macros from one workbook to
another but am still stuck.......

A colleague of mine wants to create several macros for the whole team to use
and save them on a workbook (or several) on the server for us all to gain
access to. The aim is for us to open these workbooks and be able to somehow
copy the macro onto our own PC.

How would we do this?

Somebody suggested creating an Excel Add-In and save the macros into there
but not sure what this means or how to go about it.

can anybody offer any more ideas?

Thank you.

Louise