Excel file referencing a large central macro file?

[akira919]

Hi there,

I am working on 2 major excel dashboards that has many macros. I am thinking of consolidating all of the tools and macros into one VBA file, so that there will be one file of "common macros" which I can place onto sharepoint and have all of the spreadsheets I develop in the future point to that one file and use its functions.
Are there any solutions that can solve it directly, and get close to it?

Thanks!
Alan