You can allow users to select locked and unlocked cells on a protected
sheet.

If you can select.........you can copy and paste to another sheet.


Gord Dibben MS Excel MVP

On Fri, 3 Oct 2008 08:40:00 -0700, Got my CWC
wrote:

How can I copy the values from a protected sheet in an Excel doc without
unprotecting the sheet? I want to be able to paste the values into another
doc. Any ideas? THANKS!