Double Click or F2 Cells in a Protected Workbook - see the cells used in a formula
Please allow users to double click a formula in a protected workbook to see which cells are pulled into the formula. I still want to know how the formula is working even though I can't change it.
Kenneth Barber commented
I agree with Roy's 1st sentence. Fortunately for Pam, if you really want to see a formula, you can forcefully unprotect the sheet with this free add-in:
Since all password protection in Excel can easily be broken, companies are best off removing sensitive information before sharing spreadsheets rather than relying on the password to keep people out. Unfortunately, not everyone knows this, and I have encountered a case where a company relied on the password protection for a public-facing spreadsheet. They have since switched to sharing PDFs with the public instead.
The password protection in Excel is probably purposely weak so that people can unprotect a critical spreadsheet if they really need to, especially if the developer left the company or forgot the password. This saves Microsoft quite a few angry and frantic tech support calls from users insisting that "there must be a way" to get into the spreadsheet.
Part of the reason for someone to protect a formula is so that YOU, the user, do NOT see it. From reading about various protection elements over the years it seems likely MS is aware of this and the odds would be, given their pathetic protection features, that they would consider those users' proprietary concerns over yours, if only to not weaken/lessen and already sad feature set.
They might even get sued if all of the sudden one of their major protection features was shot full of holes and spreadsheet creators felt they lost money due to it. A lot would not even be sellers of the spreadsheets, but rather bidders, for example, on public contracts. Documents, spreadsheets in electronic form included, are often available to the public and so their competitors could analyze their spreadsheets for "what's behind the bid" to better tailor their next bids to beat them.
Who knows though, right?