excel class module as add-in??

[shetlandbob]

Hi All,

I have an excel vba class module which I would like to save and have as an option for others to use as an add-in?

We write a lot of macros to process data where I am and it would be good to have a core set of macro's that is available for users to add-in to there own projects.

Ideally they would only see the code and not be able to modify it, i.e. use the "object" to handle, process, access data etc.....

I have tried to save it as an xla applicaiton and then add it in using the tools/add-ins option, but when I try to write code to access the class it does not know what it is (user defined function not defined)? Also the code is there for anyone to change (this is not ideal from a QA standpoint).

I know I could put the class modules into the default XLSTART directory of all users, but dont want this as not everyone will want to always have access to all the classes (and it is still modifyable).

Anyone have any ideas/suggestions on how I can do this? Am I correct in think a dll is the way to go on this? (i've not done that with excel and vba?)

Thanks in advance.

Bobster

 

[fredericofonseca]

As for modifing the code you can password protect the project for viewing. This will deter the common user.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com