I am faced with a problem where I would like to break out commonly used code that has been duplicated in a number of spread sheets and put this common code in a separate macro sheet that is automatically loaded when Excel starts up.

The problem is that it appear that only sub procedures becomes available/visible to other sheets.
My question is: Is it possible to access functions and sub procedures in a auto loaded sheet from within other spread sheets?

I also need to know if it is possible to put generic class modules in a starup macro sheet and still be able to access it from other sheets?
I have commonly used properties class definitions that I would like to create instances of from other sheets - but I do not want to dublicate these class modules in each spread sheet - hence the idea of putting them in a auto loaded macro sheet.

All above tasks would be accessed from within sheet specific macros.

/g
--
Can't wait getting my hands on a real programming language such as Java