You cannot. instead you can save the variable to a unused cell or a named
range duing workbook close event and get that during Workbook open event.

If this post helps click Yes
---------------
Jacob Skaria


"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