I think I would set up a coordinator who would review the code to make sure it
worked ok.

Then that person would be responsible for consolidating all the macros into a
single workbook (or addin). Then that single workbook/addin would be located on
a common network drive (or distributed to each user).

If you make it an addin, you'll have to give the users a way to run the macro.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

In xl2007, those toolbars and menu modifications will show up under the addins.

cmarion wrote:

I am in a networking environment and we are recordingmacros to run on
standard, .csv reports for limited usage by individuals. Most people
recording the initial macros are beginner to intermediate users trained to
use the macro recorder and we are trying to keep it simple. So far the
easiest way to distribute the macro is to open the Visual Basic Editor,
export the module with the macro, email it or copy to the end user, then
import the .bas file onto specific user's computer.

Our problem is that most users have never created a macro, let alone one
saved in the personal macro workbook and therefore there is no PERSONAL.XLS.
The work-around is to record a short macro in the Personal Macro Workbook,
thus creating the PERSONAL.XLS. Is there a more elegant solution?

Copying someone's PERSONAL.XLS to another computer copies too many other
macros.

--

Dave Peterson