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).
|