I have asked this before but nobody got back to me, so i'm guessing i didn't
explain clearly enough.

My task has been to create a quiz for work collegues, i have done this and
am now trying to 'jazz it up' a bit.

I have several sheets of quesitons, and would like to create a graph to show
the results. (eg 8 out of 10 etc). the graph will be displayed on the first
page and show the results of previous attempts at the quiz.

Is there any way that i can store the results (in the form of a graph) of
the quiz when the user closes the sheet, but also clear the answers given so
that when they try again the quiz is 'refreshed' and all answers are blank.

My VBA skills are very very rusty so the more detailed the help the better.
Thanks