How do I reveal answers in an Excell Quizsheet

G

Ged

This has been driving us mad in the office for days now. It's an
excell quiz containting lots of little characatures. Essentially
under each little picture there are 2 boxes. The top one is empty and
the bottom one has " WRONG " written in it. When you get the correct
name in the top box the wrong changes to correct and your score goes
up by 1..

Suffice to say we've all given up on several of them but how can i "
reveal " the remaining answers? I used to cut and paste the quizzes
into a blank sheet and then autosize the columns to reveal the answers
but this ain't working..

Also, there is no indication in the boxes as to formula and what cells
they are checking the answers against...

Any clues so that I can uncover the secrets!!

Thanks again

Ged
 
N

Nufk@mp

This has been driving us mad in the office for days now. It's an
excell quiz containting lots of little characatures. Essentially
under each little picture there are 2 boxes. The top one is empty and
the bottom one has " WRONG " written in it. When you get the correct
name in the top box the wrong changes to correct and your score goes
up by 1..

Suffice to say we've all given up on several of them but how can i "
reveal " the remaining answers? I used to cut and paste the quizzes
into a blank sheet and then autosize the columns to reveal the answers
but this ain't working..

Also, there is no indication in the boxes as to formula and what cells
they are checking the answers against...

Any clues so that I can uncover the secrets!!

Thanks again

Ged
Click to expand...

We get lots of these at work, invariably the sheet is protected and
the formulas and answers are hidden. I have a nice little addin that
breaks the protection to allow you to observe the manner in which the
sheets are hidden (for research purposes only obviously), mail me if
you want it.
--

~~~~~~~
Nufkamp
~~~~~~~
And I can still see your Dad,
Running after me with a shovel in his hand.
I don't remember much after that.....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I switch off "reveal codes" in an Outlook 2007 email? 2
how do I create an assesment test that records answers in ppt. 2
How do I get both horizontal and vertical frozen panes in Excell 3
How do I place an "x" in a box? 1
How do I setup multiple choice with click to review answers? 2
In Excell, how do I change the date from 39443 to 12/27/08? 2
How do i make the contents of Combo Box random? 1
How do I transfer info that is in word into an excell format 4

Top