Best method of distributing code

[Guest]

Hi,

I have a workbook that many users use. A create a template and place it in
a central location on a network drive. It has macros.

Periodically I need to revise or create new macros and currently that
creates a problem because I need to acess each of the workbooks created by
the users and change the cose.

What is the best / preferred method of having the code reside in a central
location so when the users opens their own workbook it will always go back to
this location and use the central version.

Thanks in advance..

 

[Dave Peterson]

If you can split the code from the data, your life might be easier.

If you create an addin (*.xla) that has all the macros you use, then you can
update that addin when you have to update the code.

If the data changes, you'll still be stuck, though.

If you go down the addin street, you'll have to give the users a way to run the
macros.

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)