Macro Help!!!!

[James_Newton]

I have created a macro that runs when you open my template, this macro asks you various questions and enters your replies into various cells.

However when I save the completed form and go back in to it later the macro re-runs itself when I open it, is there any way to stop the macro from running once the documnet has been saved!

Thank you

[Zurn]

Perhaps you could make a Checkcell (boolean: TRUE or FALSE)....

When opening, the cell value is FALSE so the whole macro is running.
When saving, put the cellvalue to TRUE

Next time, when the macro is opened, it checks the cellvalue, and true means end the macro.


SO

Sub Macro ()

If Cell( , ).value then
exit sub
Else

<enter here your current made macro>

End if

End Sub

[Zurn]

Sub Macro ()

If Cell( , ).value then
exit sub
Else

<enter here your current made macro>

End if

End Sub

After <enter here your current made macro>
You have to change te cell( , ).value=true


Forgot, sorry

[James_Newton]

Cheers Zurn