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.


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

You could create a hidden name in the workbook.

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

--

John Green - Excel MVP
Sydney
Australia


"Stuart" wrote in message ...
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.


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

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.

"John Green" wrote in message
...
You could create a hidden name in the workbook.

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

--

John Green - Excel MVP
Sydney
Australia


"Stuart" wrote in message
...
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.


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






---
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