DocVariable in Excel ~ Similar to word

[sera]

I need to store a variable in an excel document. In word this is done by activedocument.variables("blah") = "test this is a test"

I need to find an equivilant in Excel. I would rather not use the CustomDocumentProperties because the user can change this data. I will resort to this if i have to.

Thanks

Sera

 

[PHV]

An xlVeryHidden sheet ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886