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, or get close to it?

Thanks!
Alan