Another way, along the lines that Tom Ogilivy has mentioned, would be to
simply link from the cells on a protected sheet to an unprotected one, either
in the same workbook or a new one and just stretch the area to fit. You can
retrieve the values on the protected sheet that way and from the copy you can
do pretty much what you want with them. However, this method does not show
you formulas used. But a little VBA code can overcome even that minor
inconvenience.

"kyoshirou" wrote:

Have read some posts on lock cells, tag. Many reply that this protection is
easily breaks. what does that mean? how do we go break them, other than
password protection type?