Suvive value of Public variable
The only way to do this is to save that value before closing the file, and
load it when the file is loaded (using the workbook open event, for example).
Places people might store their variable values:
* hidden worksheets
* separate files (like a txt or xml file)
* as custom document properties
HTH,
Keith
"Kentae" wrote:
Hi
I want my value in a Public variable (string) will suvive after save and
close dokument until I open it next time.
Thanks in advance
Kentea
|