How to share macros from personal.xls?

C

Clif McIrvin

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!
 
G

Gord Dibben

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 Tools>Add-ins


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top