View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Calling Add-In subroutines from other modules

Steve,

With the add-in loaded in VBA, go to the Tools menu and choose
VBA Project Properties. In that dialog, give the project a
unique name, like "MyAddInProject" or something. Then, open
workbook which will reference the add-in project. Go to the Tools
menu, choose References, and put a check next to the add-in's
project (not file) name.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"sclark" wrote in message
...
Still don't get it. The addin (my custom Add-In) which is

visible in the project window for ANY workbook I have open, is
not in the list of references, so I cannot select it via
Tools/References menu. I can try the application run as well.
Any thoughts?

Steve