Paul_Hossler
08-15-2009, 08:38 AM
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
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