If you have a spreadsheet that has cell protection on it, and you can’t even select the cells to copy and paste them into another workbook, here’s an easy way around it. Upload the spreadsheet to Google Docs. Their spreadsheet program will remove the protection. You can then export the file from Google as XLS and open it in Excel, without the protection.
The formatting may be a bit different, and you might lose some macro functions, but it should get most everything. I have not tried it with a password protected Excel sheet yet.