Excel VBA

[MR From Texas]

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?

 

[Ron Rosenfeld]

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?

What happened when you selected "Browse" in the References dialog box and
navigated to the folder in which the addin is stored?
--ron

 

[Barb Reinhardt]

Try selecting it using Tools-Addins and then try to set the reference in the
workbook.