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

[xoom3]

The link doesn't work.


"Mallycat" <[email protected]> wrote in
message news:[email protected]...
>
> Try this XLA I have attached
>
>
> +-------------------------------------------------------------------+
> |Filename: password.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=5029 |
> +-------------------------------------------------------------------+
>
> --
> Mallycat
> ------------------------------------------------------------------------
> Mallycat's Profile:
> http://www.excelforum.com/member.php...o&userid=35514
> View this thread: http://www.excelforum.com/showthread...hreadid=561372
>

[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.

xoom3 wrote:
>
> 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

--

Dave Peterson

[Saruman]

Or maybe you could go here

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

--
Saruman

---------------------------------------------------------------------------
All Outgoing Mail Scanned By Norton Antivirus 2003
---------------------------------------------------------------------------

"xoom3" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>