this is great. really helped me. Could not get it otherwise.

The reason this works is all projects are given the default name VBAProject in all workbooks

Excel needs a different project name in your .xlam file to be able to distinguish where the functions are held.

You have to save with the new project name and re-install into the reference files as in the answer.