Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
A WS a basically a class model, so you can add either Public variables or
Property Get/Let. Also Enum and other class type constructs. 'On ThisWorkbook module Public Enum WS_Type WS_Basic WS_Totals WS_Calculation End Enum 'On a WS module Private mTester As WS_Type Public Property Let Tester(vData As WS_Type) mTester = vData End Property Public Property Get Tester() As WS_Type Tester = mTester End Property NickHK "Thelonious Monk" wrote in message ... Is it possible to create custom properties at the worksheet level? I want to set a property that will identify a worksheet as a particular type. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Spreadsheet Properties | Excel Worksheet Functions | |||
Custom File Properties | Excel Discussion (Misc queries) | |||
Custom Class and Properties | Excel Programming | |||
Worksheet Custom Properties | Excel Programming | |||
Custom Properties | Excel Programming |