Instancing on Classmodule on Excel 2002
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 |
Instancing on Classmodule on Excel 2002
Chip Pearson has posted on this topic several times:
http://groups.google.com/groups?as_q...rson&lr=&hl=en -- Regards, Tom Ogilvy "Tetsuya Oguma" <Tetsuya wrote in message ... 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 |
All times are GMT +1. The time now is 11:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com