Thank you for your reply.
I will read the website for add-ins and see how I go.

Thanks again.

Louise

"DS-NTE" wrote:

I think your best option is to create an Add-In.
Read here to get you started:
http://www.fontstuff.com/vba/vbatut03.htm

Do some Googling to find more help, maybe get a book that covers the topics
of cretaing Add-Ins.
Its not difficult at all...

knut
"Louise" skrev i melding
...
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