Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Common set of macros
Hello,
I have a workbook with buttons on some of the worksheets, click-event handlers, automacros and general macros. I made four copies of the workbook, modified some headings, and shared them for data input by four different groups of people. Everything works fine until I need to make changes to event-handlers and macros: Any change in VBA code must be done four times, once for each of the four WBs. There ought be a better way to do this. Suggestions are most welcome. (I use Excel XP). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Common set of macros
You could put all your code in a separate workbook and make that workbook an
add-in. Just reference the Add-In Workbook on your Button Click Events. Making the workbook an Add In will enable you to only have to correct one workbook instead of four. Just choose the workbook with the code and Save As Type Add In Hope this helps! If so, let me know or just click "Yes" below -- Cheers, Ryan "robot" wrote: Hello, I have a workbook with buttons on some of the worksheets, click-event handlers, automacros and general macros. I made four copies of the workbook, modified some headings, and shared them for data input by four different groups of people. Everything works fine until I need to make changes to event-handlers and macros: Any change in VBA code must be done four times, once for each of the four WBs. There ought be a better way to do this. Suggestions are most welcome. (I use Excel XP). |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Common set of macros
Thanks RyanH for your reply.
I am now exploring how to proceed. Expounding on your idea, I guess I have to: 1. Save one of the workbooks as an Addin, and rewrite event handlers and automacros as procedures with exact same parameters. 2. Replace all code of event handlers and automacros with procedure calls; 3. Set reference to the Addin for each of the 4 workbooks. That will be quite some work to do! "RyanH" wrote ... You could put all your code in a separate workbook and make that workbook an add-in. Just reference the Add-In Workbook on your Button Click Events. Making the workbook an Add In will enable you to only have to correct one workbook instead of four. Just choose the workbook with the code and Save As Type Add In Hope this helps! If so, let me know or just click "Yes" below -- Cheers, Ryan "robot" wrote: Hello, I have a workbook with buttons on some of the worksheets, click-event handlers, automacros and general macros. I made four copies of the workbook, modified some headings, and shared them for data input by four different groups of people. Everything works fine until I need to make changes to event-handlers and macros: Any change in VBA code must be done four times, once for each of the four WBs. There ought be a better way to do this. Suggestions are most welcome. (I use Excel XP). |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Common set of macros
It won't be to bad. I had to do it myself.
Hope it helps! Don't forget "YES" below -- Cheers, Ryan "robot" wrote: Thanks RyanH for your reply. I am now exploring how to proceed. Expounding on your idea, I guess I have to: 1. Save one of the workbooks as an Addin, and rewrite event handlers and automacros as procedures with exact same parameters. 2. Replace all code of event handlers and automacros with procedure calls; 3. Set reference to the Addin for each of the 4 workbooks. That will be quite some work to do! "RyanH" wrote ... You could put all your code in a separate workbook and make that workbook an add-in. Just reference the Add-In Workbook on your Button Click Events. Making the workbook an Add In will enable you to only have to correct one workbook instead of four. Just choose the workbook with the code and Save As Type Add In Hope this helps! If so, let me know or just click "Yes" below -- Cheers, Ryan "robot" wrote: Hello, I have a workbook with buttons on some of the worksheets, click-event handlers, automacros and general macros. I made four copies of the workbook, modified some headings, and shared them for data input by four different groups of people. Everything works fine until I need to make changes to event-handlers and macros: Any change in VBA code must be done four times, once for each of the four WBs. There ought be a better way to do this. Suggestions are most welcome. (I use Excel XP). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining two ranges based on common a common value | Excel Discussion (Misc queries) | |||
Macros common to several workbooks | Excel Worksheet Functions | |||
Common footer but not common margins please -(Page 1 of 2) etc | Excel Discussion (Misc queries) | |||
saving macros to a common folder for all users | Excel Programming | |||
saving macros to a common folder for all users | Excel Programming |