View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Thief_ Thief_ is offline
external usenet poster
 
Posts: 25
Default Modules and add-ins

An addin is the best way to go. In the VBE, Click on This Workbook and
change the IsAddin property to True then save the workbook as <whatever.xla

You can now use that wb as an addin!

--
|
+--Thief_
|


"SmilingPolitely" wrote in message
...
I have a large number of functions and subs stored in a module. I would
like to have this code available to all of my Excel apps without having
to import the module each time I create a new workbook.

Do I (somehow) make my module an add-in? If so, how? If not, what
should I do?

Any help is appreciated.



Excel 2002 on Win XP Pro (SP2)