excel workbooks_BeforeClose

This macro works fine, except, when execuited all of my variables are reset. I wish to test a Flag to determine what I want to do next, but the Flag is always reset. Any help is greatly appreciated.
OlieH