View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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!