I need to make two macros readily available to one primary user, who
will then create a variety of workbooks with those macros attached and
pass them along to end users. I'm trying to avoid having either the
primary user or the end users go through any code installation
routines; they should be able just to use the macros. But everything
I've read either assumes that I'm writing macros only for myself or
that I'm distributing them to technically savvy users.

I tried to put the macros on toolbar buttons, but there were problems,
so then I tried keyboard shortcuts, which got me closer, but there are
still problems. One user can use the keyboard shortcuts successfully,
another can only use one of them, one of the macros shows up with an
invalid name in the macro list but still runs from the keyboard....etc.
All kinds of weird stuff.

I'm trying to do things like I would in MS Word, and it's just not
working. I need the "right" way to do this so I can feel confident that
by the time the real end users get their hands on the workbooks, these
macros will work for them. Should I do these as add-ins? Do the users
have to do anything techie at all to access them, or can I automate
that for them?

Thanks ----