Need Help programming treasure hunt sheet!!

[Rachael]

Hello. I originally put this in the general, but I think this is more
appropriate. 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!!

I forgot to also mention - I know NOTHING about VB script or programming at
all. I tried creating a button in excel and it took me there. So unless
someone tells me what to write to make a button that has a password that
unlocks a cell - I can't figure it out on my own (and I don't think I can
learn VB in 3 days!)

 

[Barb Reinhardt]

Without VBA, I'd probably do it this way.

Put all of your questions on a sheet that you ultimately will hide.
On another sheet, as they enter something for an answer, display the next
question. I'd do something like this

A1 would be first question
A2, 2nd question
a3, 3rd question

B1, 1st answer
b2, 2nd answer
b3, 3rd answer


A1: =Sheet2!A1
A2: =if(isblank(Sheet1!B1),"",Sheet2!A2)
copy a2 down.