start a macro or procedure based on user putting an x in a cell
 

How would I start a macro /
procedure to send the user to different parts of a spreadsheet, after a user
checks a yes or no in a cell after a question?

Here is the situation:
The user is completing a very long spreadsheet. The user must answer yes or
no to several questions. Depending on the choice of the user, they will need
to complete different parts of the spreadsheet. For example: Question 46:
Do you have a flat roof? Two cells are set aside for each choice: Yes or No.
If the answer is yes then they will need to go to and answer question 55.
If they answer no, they must answer Question 47 is €œDo you have an attic with
a crawl space?€� Again Yes or No. If they answer Yes or No the user must
answer different questions etc. The problem is, that I have users at remote
sites filling the data in and they just answer all the questions, regardless
of the instructions, and that results in incorrect calculations! It takes
too much time to go back and fix their data, if I can!

Any help would be appreciated greatly! Thanks!