Unprotect Worksheet.

[xoom3]

Hi,



Is there anyway to unprotect a worksheet to allow me to see the formula used
in certain cells.



I'm prompted for a password but do not have the password.



Regards,



Doug

 

[Mallycat]

Try this XLA I have attached


+-------------------------------------------------------------------+
|Filename: password.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5029 |
+-------------------------------------------------------------------+

 

[xoom3]

The link doesn't work.

 

[Dave Peterson]

Maybe you should go back to the developer and ask for the password or a copy of
the workbook with the worksheet unprotected.

 

[Saruman]

Or maybe you could go here

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