Yes. This is what I want. I just don't know how to program the button to do
that at all. I know nothing about programming (except basic HTML)....

"Otto Moehrbach" wrote:

Rachael
I can imagine something like this: You have a hidden sheet with a list
of all the clues, in order, in Column A. In Columns B,C,D,E you would have
4 possible answers/passwords for each clue. For each clue, one of those
answers is the correct one. In Column F of this hidden sheet, you would
have the correct answer.
On the main sheet, the sheet that the user sees, you have the first clue in
say, Column A. You also have a button at the top with frozen panes active
so that the button is always visible. Next to the button you would gave a
Data Validation cell.
The user clicks on the button. A macro will then fire that will set the 4
choices for that clue as the list in the DV cell. The user will then click
on the down-arrow of the DV cell and will see the 4 choices. He clicks on
his choice. The macro will then find the clue in Column A of the hidden
sheet and will check if the answer he gave matches the entry in Column F of
the hidden sheet. If it is, it will copy the next clue and paste it in that
first sheet and will reset the DV cell with the choices for that clue. If
his choice is wrong, the macro can display a message box telling him
whatever you want. You might also want a "START" button to reset everything
back to the first clue.
Does this sound anything like what you are looking for? HTH Otto
"Rachael" wrote in message
...
Hello. I want to set up a simple locked down spreadsheet for a treasure
hunt.
I want there the be an initial cell on the screen with a clue. I want
there
to be some kind of button where they can click and put in a
password/answer
and then the next cell will populate with the next clue.
I'm a novice user of excel - fine for basic tables and some forumlas, but
that's it.
I need to make this spreadsheet for work for next week (so, finishing it
this weekend for Monday) for International Talk Like a Pirate Day (Sept.
19th). Thanks!!