Worksheet Properties? How to Tag sheets with data?

[winxpdows]

Any way to access Worksheets with custom properties like the Document Properties?

I am building an addin and I need to figure out when a user is on a worksheet that the addin created. For now, I just "hide" a word in the BA1 cell and have the addin check that cell when a procedure is called to see if the user is on a "valid" worksheet for use by the add-in.

The problem is that if the user deletes a column then the BA1 cell is no longer populated and the addin doesn't work on that worksheet anymore. I can't use the Sheet name itself because the user needs to be able to change the names if desired.

I am looking for another way to "tag" particular worksheets so that I can tell if the addin should run on them.

I figure if there are custom properties like Document properties, I can set those up and use them, but I can't find any info.

The other idea was in the VBA Editor, the properties window of a worksheet has both a (Name) field and a "Name" field that is shown on the bottom tabs of a workbook. Anyone know how to access the (Name) field? I can use that if I have to.


Thanks in advance for any help!

 

[winxpdows]

Found a solution...

ActiveWorksheet.CustomProperties.Add Name:= "TEST", Value := "101"
Msgbox ActiveWorksheet.CustomProperties.Item(1).Name
Msgbox ActiveWorksheet.CustomProperties.Item(2).Value