Create a new file using FileNew.

Copy the module or macro from the old workbook into the new one.

FileSave AsFile TypeAdd-in(*.xla)

You will find that option at very bottom of File Types list.


Gord Dibben MS Excel MVP

On Thu, 9 Nov 2006 12:47:02 -0800, Erin wrote:

How do you create an add-in? I am not a developer & I could not find
information on how to in the Excel Help.

"Gary''s Student" wrote:

Create an add-in and distribute it.
--
Gary's Student


"Erin" wrote:

I put together a macro that I use regularly to separate data that is imported
into Excel from another software product. Is their away to make this macro
available globally on my company network for other Excel users to use?