Can a workbook be 'Tagged' as follows:?

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

I would like to find a way to reliably 'tag' a workbook, such that
a simple check via code will return the 'type' of workbook the
user is working with.

I will place the 'tag' when the workbook is created.

Later, I would use code to check the type of workbook, and direct
further code accordingly.

Say there are 3 types of workbook, and where the user must not
be able to change the 'tag'.

Can this be achieved, please?

Regards.
 
You could create a hidden name in the workbook.

ActiveWorkbook.Names.Add Name:="Tag", RefersTo:="Type1", Visible:=False
 
Thanks for that.

Is this going to work in both Excel 2000 and '97,
and how do I reference/check the existence of
the new name, please?

Regards.
 
Back
Top