I have set up a worksheet and proteced the valuable cells, so that users can
copy and paste data into a specified section and the worksheet claculates the
variables for them. I have unlocked the cells for people to copy data into,
however, when they copy the data across, the worksheet protects all of the
cells that they have copied across, and they cannot get access to their data.

Is there any way of stopping this - apart from making them unlock the cells
from the data that they copy in the first place??
Thanks