Solved: Excel equivalent to MS Word's DOCVARIABLE?

[Paul_Hossler]

Word VBA has the DOCVARIABLE that is persistent and stays with the document.

Does Excel have something similar, or can anyone suggest an alternative?

Right now I kludge settings in as a CustomProperty or a Name, either of which might be changed or deleted by the user.

Storing settings on a VeryHidden worksheet seems like a roundabout way, compared with the DOCVARIABLE concept.

Paul

[Bob Phillips]

You can use a name and hide it

[vba]

Dim nme As Name

Set nme = ActiveWorkbook.Names.Add(Name:="myVar", RefersTo:="Hidden Value")
nme.Visible = False
[/vba]

and then there is always the registry.

[Paul_Hossler]

nme.Visible = False

didn't know about that

thanks #2

Paul