I can't run a macro on exit

[Lance T]

I am running Office XP with SP3. I am trying to create a form that when a
checkbox is checked, it will run a macro. I can run the macro fine thru the
tools>macro>run macro, and it works. I even tried the example they list
under "Automating your form". I have a checkbox for "Married" and saved that
as a template. I record a macro which works above. I save it to the template
folder for "Married" I double click and select the macro to run on exit. It
doesn't ever run. suggestions?

Thanks,
Lance