Custom properties for worksheets
Hi
Enter something like this on top of the (or all) sheet's module:
Public GreatSheet As Boolean
and you can set it to False or True from anywhere and read it from anywhere,
like:
Sheets(2).GreatSheet = True
Msgbox Sheets(1).GreatSheet
HTH. Best wishes Harald
"Thelonious Monk" skrev i melding
...
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!
|