G'day everyone...new boy here hoping to tap into the genius that this forum appears to generate!

I have created an Excel Workbook which is basically a quiz (actually, it's a professional Test). As a first attempt, I am very happy with it but I need to progress it further...and that's where I have come unstuck!

Don't even know if this is possible but...On the first page, there is an option for the student/user to input their name etc. Then Instructions on the next page and the test on the third page in the form of multi-choice, 'drop down' answers format. I have a hyperlink at the bottom which says similar to "When you have completed the test, press here to see your results". This will (surprisingly, take them to their own individual result). Anyway....

1. Is it possible for this hyperlink box to only be displayed when ALL the questions have been answered? i.e. All drop down boxes have been used?

2. Is it possible for the result (along with their individual names and scores) to be saved on another sheet? This of course would be supplemental (i.e. When the next person finishes the test, their name would be next on the summary etc.)? I would then have a whole list of who had taken the test...when...and what their score was!

3. Finally, and I know I'm pushing my luck, but is it possible for this summary sheet of names and scores to be hidden?

I apologise for the huge list of questions..and I'm pretty sure I'm asking too much. However, to stop and old, bald man losing anymore hair...please help if you can!

Either way, please keep up the excellent work...it really is a treasure trove in here.

Best wishes

A J