Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How does one share a class module among XLS files? I can share macros for
example by storing them in Personal.xls or by creating a VBAProject reference to the file which contains the code. I presume there's a way to share the code in a class module short of replicating the module it in every xls file? I've tried putting the code in a class module contained within a Library.xls file that's already referenced but when I try to use the class code I get an error that the user-defined type is not defined. It works though if I replicate the class module in every XLS file that wants to use it. Plainly I'm missing something. Thanks... Bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
Class module | Excel Programming | |||
Class module | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |