Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Best method of distributing code
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.. -- Andrew 290607 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Best method of distributing code
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) Andrew wrote: 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.. -- Andrew 290607 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Distributing Paste String | Excel Discussion (Misc queries) | |||
distributing each characters on a cell | New Users to Excel | |||
Distributing a Cell Value | Excel Worksheet Functions | |||
Distributing - EXcel and help file | Excel Discussion (Misc queries) | |||
distributing numbers | Excel Discussion (Misc queries) |