Is it possible to reference class modules in without adding them to a workbook in Excel/VBA?
I know that I can reference class modules in a workbook or addin, but when doing this, they are "Public Not Createable", which means that I need to add a function in the workbook/addin that I reference, that creates an instance of the object, e.g.:
Public Sub NewInstanceOfSomeObject() as SomeObject
Set NewInstanceOfSomeObject = New SomeObject
Can I in some way reference class modules, so that they can be used as if they where part of the workbook?
COM/VSTO etc. is unfortunately not an option due to extremely bureaucratic and strict security policy, which make it take waaay too much time to order an dll registration for each new user that uses the sheet. Unless there is a not too complex way to use it without registration?