If the worksheet protection is simply to prevent changes to forumlae and formats etc, then the whole sheet can be copy/pasted to another workbook and the protection is removed by doing this. Then copy/paste it back. But if you've got links though, this could be messy.
If the protection is to prevent access by unauthorised persons, then you'll need the above password removers.
This is also useful when you get those Excel based quizzes emailed round and you have to type the answer in. If your answer doesn't match the quiz's answer exactly (including their typos), you get it wrong. However, you can copy/paste the quiz into another workbook and get the answers in the correct format.

Cheers
Whirls