Can I use general procedures in xla files, beyond only functions? I would like to use xla files to store many procedures that are not functions (sub <name>).
If positive, how do I invoke a procedure that resides in a xla file?
Thanks in advance,
Marcelo Rychter
Hi
1) yes you can.
2) Say you have a sub in module1 in your addin.
The addin has been enabled in you tools, addin area.
Please Login or Register to view this content.
In a general module in an open workbook, enter the code.
Run the code and the message fred should appear.Please Login or Register to view this content.
If you want to, create a toolbar icon and attach the macro to that button.
HTH
rylo
Last edited by rylo; 08-21-2007 at 06:39 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks