Excel 2013/2016 Import Modules every time you open Excel



  • So I've been asked to figure out a way to sort and highlight some data. Ok not a big deal, already done.

    The question I have is there a way to import modules every time I open excel?



  • Maybe a way to help in finding a solution, what if you open a sheet that requires those modules, then open a new sheet to do work?



  • Well the report is automatically generated from a system we use here. So if possible, rather than having people have to open 2 files, I'd like the modules to just import when excel launches.

    I suppose I could bury the modules into the personal file. But I'm not sure if that't the best approach.