Questions from a beginner

S

sweeney

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………
 
T

Tom Ogilvy

Here are some articles that may be of interest:

http://support.microsoft.com/default.aspx?scid=kb;en-us;830502&Product=xlw
How to customize menus and menu bars in Excel

Here is an article which talks about attaching toolbars:

http://www.microsoft.com/exceldev/articles/toolbatt.htm

Here is an article about creating commandbars with code:
http://msdn.microsoft.com/library/techart/ofcmdbar.htm

Here is another article or two you might find useful:
http://msdn.microsoft.com/library/backgrnd/html/msdn_addins97.htm
http://msdn.microsoft.com/library/officedev/odeopg/deovrcreatingexceladdin.htm
http://www.microsoft.com/exceldev/tips/addins.htm
These are about distributing applications

http://support.microsoft.com/?id=159619
XL97: Sample Macros for Customizing Menus and Submenus

http://support.microsoft.com/?id=213550
XL2000: Sample Macros for Customizing Menus and Submenus


http://support.microsoft.com/default.aspx?scid=kb;en-us;166755
File Title: Customizing Menu Bars, Menus, and Menu Items in Microsoft(R)
Excel 97
File Name: WE1183.EXE
File Size: 58041 bytes
File Date: 06/20/97
Keywords: kbfile kbappnote
Description: This Application Note can help you learn techniques for writing
Visual Basic(R) for Applications code to customize menus in Microsoft Excel
97. This Application Note contains code examples that you can use with the
following elements: menu bars, menus, menu items, submenus, and shortcut
menus.
 
Top