What version of excel are they using?

I couldn't duplicate this behavior in xl2003. But maybe the behavior changed???

Tell the users to copy from the formula bar and paste into the formula bar.




Excel_oz wrote:

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

--

Dave Peterson