ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel VBA (https://www.excelbanter.com/excel-programming/438608-excel-vba.html)

MR From Texas[_2_]

Excel VBA
 
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

Excel VBA
 
On Tue, 19 Jan 2010 17:07:01 -0800, MR From Texas
wrote:

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

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

Barb Reinhardt



"MR From Texas" wrote:

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?



All times are GMT +1. The time now is 06:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com