Use a custom function in any excel file

So I made some really cool functions for analysing data for my boss, but any time I open a new excel file I have to add a new module to that file, copy and paste my code in it so I can use my functions. Is there a way to make it so that I do not have to do this? I am adding the module to VBAProject (dataForMyBoss.xlsx). I have tried adding the module to the PERSONAL.XLSB, but then I can not access my functions. I am assuming for my functions to have global scope it needs to be in ther PERSONAL.XLSB, but I can not use them there.

I think the way forward is to

I think the way forward is to use an Excel Addin.

Look at

http://office.microsoft.com/en-us/excel-help/load-or-unload-add-in-progr...