View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
OlieH OlieH is offline
external usenet poster
 
Posts: 39
Default How can I save variable when 'end'? The user then reactivates the

I auto_open a macro, set variables then exit the mcro to allow users to
directly enter values in the worksheet. When they are through they press a
button that reactivates the aarco. My problem is the variablest that I have
set are lost. Is there a way to save these variables. I currently save then
in portion of a work sheet the user does not see. I would like a better way.
thanks for the help
OlieH