Short version:
i would like to know if it's possible to run macros from external source (ie: another workbook or exported file).

Long version:
i have created a series of 4 workbooks to store figures for different aspects my place of work. All these work fine but the company i work for has 40 sites, each site requires a complete set of these 4 workbooks, totalling 160 workbooks. I was thinking that alot of the size of these workbooks are just repeated forms and sub routines and if i could get them all to run forms and sub routines from one central location the space saved would be massive.

I hope this makes sense, any ideas ?