I use the two modules listed in the link below in a number of spreadsheets and I thought it might be better to put them into an xlam file and configure this file as an add-in so I don't have to copy these modules to my project every time I need them

The trouble is they only seem to work when part of the file I'm working in and don't work as part of the add-in file. Is there something in the code that I could change to allow them to work in the xlam file without having to copy them each time?

http://www.mrexcel.com/articles/exce...-to-inches.php