I have an Excel Addin used with an excel workbook. When I try to set the
reference in VBA of the workbook to the addin using Tools - References, the
addin is not visible. However, the addin is visible when I set the addin in
excel using Tools - Addins.

Any ideas?