Thank you, Gord. However, when you said 'tell her to put it into her
Office\Library' I'm not sure how to go about doing that. When it is saved as
an .xla file, will that file appear in the Tools\AddIns available dialogue
box?

I also have custom icons and custom menu bars and would like those to be
transferred also, if possible.
--
Pauline Speed


"Gord Dibben" wrote:

Copy all the macros to module(s) in a new workbook.

FileSave AsFile TypeAdd-in(*.xla)

Send her the file and tell her to put it into her Office\Library.

She can then activate it by going to ToolsAdd-ins and checkmark it.


Gord Dibben Excel MVP

On Wed, 14 Dec 2005 13:09:40 -0800, pspeed
wrote:

I have made many macros in Excel and now that I am getting a co-worker would
like to know how to successfully copy/give them to her to use on her computer
(Excel 2003 running on XP operating system). Thx.