View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
robot robot is offline
external usenet poster
 
Posts: 6
Default 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).