Thread: Can a workbook be 'Tagged' as follows:?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Green[_3_] John Green[_3_] is offline
external usenet poster
  
Posts: 49
Default Can a workbook be 'Tagged' as follows:?
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




Reply With QuoteReply With Quote