NG help kindly gave me the following, as a means of 'tagging' a workbook:

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

How can I use this, please?

Say I need to differentiate between 3 types of workbook. How do I apply
type1, type2, type3 (using say, Tag1, Tag2, Tag3) to the workbooks?

As an example, if the value "£" were to be found in Col 5, then it's a type1
workbook, so give the workbook the private name of "Tag1". The user
must not see this name, nor therefore be able to change it.

As I understand it, at a later date, I should be able to check the workbook
when it is opened, and if it's a "Tag1" workbook, then do code suitable
for that type of workbook.

Can a solution be found for both Excel 2000 and '97 users, please?

Regards.




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.538 / Virus Database: 333 - Release Date: 10/11/2003