If I want to add options to the menubar, I use a variation of John Walkenbach's
menumaker:
http://j-walk.com/ss/excel/tips/tip53.htm

If I want to add a toolbar of my own, here's how I do it:
http://groups.google.co.uk/groups?th...5B41%40msn.com

I save the file as a .xla (addin).

Then I tell the end user to just open that workbork when they need that
functionality.

If it's a set of routines that should always be available, the user can add it
manually via Tools|Addins (and browse for their copy -- or point to a common
network file.

If there has to be separate installs (gonna be a pain to play catchup when you
have to make a change), Jan Karel Pieterse has a nice install program included
in the .zip file for his (with Charles Williams and Matthew Henson) name manager
utility.

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp/



wrote:

Anybody out there? There must be a way. How does everybody else make
macros available to non-tech end users without requiring a distinct
installation process? Please help!

--

Dave Peterson