| Home |
| Search |
| Today's Posts |
|
#19
Posted to microsoft.public.excel.programming
|
|||
|
|||
Public Variable dilemma
THIS POST IS NO LONGER NEEDED - I'LL REPOST
"Brettjg" wrote: Ok, some digestion, but not necessarily full comprehension. I haven't read your website jst yet. A few Qs: 1. I think you saying that the class module should go into TOOLS rather than PERSONAL? 2. I'd really like to set it up so that the two worksheets in TOOLS are also referred to in the same way ( Sheet("TOOLS") would be T_TL i.e. TOOLS_TOOLS and Sheet("CONTACTS") would be T_CONT i.e. TOOLS_CONTACTS). I presume that I can do that at the same time as (or instead of?) Set Worksheets = pTLS.Worksheets in the Public Property Get Worksheets. I think the statements would read Public Property Get T_TL() as Excel.Sheets Set T_TL = pTLS.Sheets"(TOOLS") End Property Would I still have the other Public Property Get Worksheets construct? Do I need a whole new Private pT_TL as Worksheet with similar following code to what you already have. This looks like it will be terrific Chip, and thankyou for your generous help thus far. As a realist, I guess that when you posted your original reply that you had to expect quite a few Qs to come out of it, eh? In the interim I'll do up some code on how I think it should be (as a start anyway) while I'm waiting for your response. Regards, Brett |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Public variable (or Public Const?) | Excel Programming | |||
| Public variable (or Public Const?) | Excel Programming | |||
| Public variable | Excel Programming | |||
| Public Variable | Excel Programming | |||
| public variable | Excel Programming | |||
Threaded Mode
