Hi all,

I am using Excel 2002 SP2 on Windows XP

I found Instancing on ClassModule that you can set it either "Private" (I
think this is default and used it as you have been using) or
"PublicNotCreatable". Can anyone tell me how to use each case? I cannot see
any documentation on this on MSDN. Also, I have this sneaky suspicion that I
have seen this somewhere else, not on VB6 but somewhere...

Cheers,
---
Tetsuya Oguma, Sydney, Australia