Do you mean "password" of protected sheet?

See this site for removing passwords.

http://www.mcgimpsey.com/excel/removepwords.html

Or view hidden formulas on a protected sheet?

You can unprotect the sheet and FormatCellsProtection. Uncheck "hidden".


Gord Dibben MS Excel MVP


On Wed, 7 Mar 2007 10:30:52 -0800, Dev wrote:

how can i know formula of protected sheet.
kindly send me mail :-