Cell protection in Excel

[Jim]

Help please!

I use Microsoft Excel in the latest two versions of
Microsoft Office to test pupils at school in mathematics
and English language.
This involves using hidden formulas and locked cells with
answers in - all protected by a password. It doesn't work!

This is even the case when access is denied to the
individual cells.
The youngsters just insert the coordinates of the answer
cells into the 'Name Box' (top left), go to the cell and
copy the answer out into the answer cell.

Am I doing something wrong?

Is there any way of preventing access by this method or
copying from a hidden/locked/password protected cell?

Jimbo

 

[Guest]

Hi,
your students seem to know more about xl than you do.
security in excel in not that great despite precautions
taken.
i don't know how you have set this up but i would put the
answers in another workbook and link the two.