excel accessing class modules in another vbaproject (Addin)

[shetlandbob]

Hi all,

I have a excel vba class module that I have created and I have saved this workbook as an excel add-in (excel2000).

I can add this in to a new workbook that I create and I can see the class module in the VB editor, however when I try to create an instance of this class the the compiler complains that the user defined type not defined?

If I move the class module into my local workbook it works.

Is it possible to access the class module that is in the excel addin?

Anyone with an idea how to do this?

Any help much appreciated.

Thanks in advance.

Bob

 

[combo]

See excelent description by Tushar Metha at

http://support.microsoft.com/?id=555159

combo

 

[shetlandbob]

thanks for the link, I found it myself about an hour ago!!

Cheers anyway