Is there a way to use a common code module and attach it to more than one
workbook? If so, how do you make its procedures and funtions available to
the workbook and the worksheets in the workbooks where it is attached.
Thanks,
Keith
Is there a way to use a common code module and attach it to more than one
workbook? If so, how do you make its procedures and funtions available to
the workbook and the worksheets in the workbooks where it is attached.
Thanks,
Keith
Hi Not sure if this is what you want but
If you put all of your code into one workbook and then save it on the save as menu select xla rather than an xls and save it as a .xla
This will save it as and excel add-on.
Then this add-on should load with excel everytime. You can the call the methods from and workbook and even have custom menus that call menus. On the menus just type the method name mymethod() or call it in code Call mymethod()
I have my own set of functions that i use as well as the excel standard ones.
Hope This Helps
No, but you code put the code in an add-in. Then you run the code in the
add-in like so
Application.Run "myaddin.xla"mymacro"
--
HTH
Bob Phillips
"keithb" <[email protected]> wrote in message
news:%[email protected]...
> Is there a way to use a common code module and attach it to more than one
> workbook? If so, how do you make its procedures and funtions available to
> the workbook and the worksheets in the workbooks where it is attached.
>
> Thanks,
>
> Keith
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks