ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Unprotect Worksheet. (https://www.excelbanter.com/excel-discussion-misc-queries/99247-unprotect-worksheet.html)

xoom3

Unprotect Worksheet.
 
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

Unprotect Worksheet.
 

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


xoom3

Unprotect Worksheet.
 
The link doesn't work.


"Mallycat" wrote in
message ...

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

Unprotect Worksheet.
 
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

Unprotect Worksheet.
 
Or maybe you could go here

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

--
Saruman

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

"xoom3" wrote in message
...
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






All times are GMT +1. The time now is 06:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com