View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default 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!