I work in an office environment where we increasingly need to create
macros for users. We are trying to tackle the task of finding a
convenient way to distribute the macros to users. Most of the macros
are for Excel, but we are also using Word 2000 and PowerPoint 200
macros.

Right now I have one Excel file on the server that houses all of our
Excel macros, I open that file and create a button on the menu bar and
assign a particular macro to that button. It gets to be tedious when
creating new macros and assigning it to a button on each user's menu
bar.

Is there a better way? I have read about add-ins in postings, but do
not understand how they work, I have saved files as add-ins, but have
no success loading them on user's computers. I would love to be able
to create a toolbar with macros assigned to it and be able to send it
to users some how. Would I need a developers kit for this? Also, any
recommendations on good books for beginners?

I am having the same situation in Word and PowerPoint, any way to
create tool bars and distribute them to users?

Any help will be greatly appreciated………