You want to protect the worksheet, but allow the user to select both locked and unlocked cells. At that point the user won't be able to edit anything, but they can still select the cells and copy them.
In Excel 2003 and earlier, if I recall correctly, the command its under Tools-->Protection-->Protect Sheet
In Excel 2007 and higher it is under Review-->Protect Sheet