GS wrote:
witek has brought this to us :
GS wrote:

You can store a value in a DefinedName, then hide the name so it doesn't
show up in lists. You do this by setting its .Visible property to False.

ActiveWorkbook.Names.Add "UniqueName", "UniqueValue", False



For now it is the only solution I know.
however value can be changed by any addin installed.

True.., so long as the addin knows the unique name.

The problem is that addin can list hidden names.
If hidden or "secure" names could only be listed by module which created
them it would be perfect.
There is such thing in c++/XLL programming but name can be accessed only
if worksheet with this name is active. It does not work for me. I have
to have access to it all time.

While anything is
possible (ergo NOTHING is 100% secure), it's logical to presume the
average user will not mess with things since their objective is to use
the file for its intended purpose.

the problem is that is a goal for a user. To find that information and
copy it to other workbooks.

It must be something which user can't read or can't find.

thanks for help.