Question/Answer programs

Hi,

I am createing educational question/answer type programs using Excel. I have encountered two problems with this:

Firstly, I would like to know if it is possible to introduce a conditional helpful
picture or diagram into the sheet if a person being tested enters a wrong response, but no picture if a correct answer has been input. I am using IF statements, but I can't get them to "recognise" pictures or graphics.

Secondly, I would like to know if I can set the worksheet to allow input in certain cells only, but not in the rest of that worksheet. In other words, I am trying to create a sheet that scores as test subject's efforts, then can be reused by other people without it being accidentally changed or damaged by them.

Is there anyone who can please help me with this?

Thank you

Hello byte_me,

Welcome to the Forum!

The picture can be done but requires writing a VBA macro to do it. As for the second question, protect the worksheet. By default as cells are "locked" which only has any effect once the worksheet is protect. Select the cells you want the user to be able to change, right click and select Format Cells.... Click on the Protection tab and click the check box labeled Locked to clear it. You can select multiple cells at time by holding down CTRL while you click each cell.

Sincerely,
Leith Ross