Custom properties for worksheets
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!
|