post the problem code

Tim

"Polarbear" wrote in message
...
I wrote a multiple choice tests in excel, it's 7 pages multiple
choice with
in cell pull down answer selections. It's also timed which affects
your score
if your fast or slow. It also keeps track of the top 10 scores. It
has 6
macros that record the time, hide the sheet your one and open the
next sheet.
The scores, including times and top 10 are listed on the final sheet
which
is just a total sheet. It works perfectly up to that point -- I
tried to
record one last macro to reset it ie add new results to top ten
list -- print
totals, clear answers, and save it blank on the first page ready
for some
one else to take. The final macro I have written about 6 times I
hit record
do everything I want it to do, but when i run it, it randomly
clears most of
the cells on the total sheet. The total sheet is not selected when
I'm
clearing the others. I know it's a lot to ask but I'm going crazy
can someone
steer me in the right direction ?