LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.programming
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
turn off subroutines NDBC Excel Discussion (Misc queries) 3 July 27th 09 01:23 PM
Calling Subroutines/User Functions from Macros Neil Strong Excel Programming 2 December 5th 03 11:03 AM
calling modules Pedro Excel Programming 1 November 13th 03 11:15 AM
variable calling in different modules. russell Excel Programming 2 October 24th 03 04:17 AM
Duplicate Subroutines Gary Elsner Excel Programming 8 September 14th 03 08:55 PM


All times are GMT +1. The time now is 11:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"