G
ghostWolf
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.
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.