I really don't even know where to start looking; or even for certain how
to identify my options, so I'm starting with a question here. (Office /
Excel 2003 SP3; XP Professional)

I have several macros in my personal.xls workbook, and now I'm being
asked to make them available to coworkers.

The task at hand is data entry, and the macros main purpose is
validation.

As presently designed, each data entry worksheet represents one paper
source data sheet.

Other than moving the macros in question into a workbook module and
placing that workbook on a network share I really don't know how to
proceed.

Assuming that there will be multiple workbooks needing these macros, is
that a reasonable soultion?

Can you point me towards examples and reference materials that shed
light on this issue?

Thanks!

--
Clif

Save your Personal.xls as an add-in named Global.xla or similar.

Store that add-in a network folder common to all users.

They can load the add-in through ToolsAdd-ins


Gord Dibben MS Excel MVP

On Fri, 20 Mar 2009 18:30:44 -0500, "Clif McIrvin"
wrote:

I really don't even know where to start looking; or even for certain how
to identify my options, so I'm starting with a question here. (Office /
Excel 2003 SP3; XP Professional)

I have several macros in my personal.xls workbook, and now I'm being
asked to make them available to coworkers.

The task at hand is data entry, and the macros main purpose is
validation.

As presently designed, each data entry worksheet represents one paper
source data sheet.

Other than moving the macros in question into a workbook module and
placing that workbook on a network share I really don't know how to
proceed.

Assuming that there will be multiple workbooks needing these macros, is
that a reasonable soultion?

Can you point me towards examples and reference materials that shed
light on this issue?

Thanks!