View Single Post
  #10   Report Post  
Dave Peterson
 
Posts: n/a
Default Forgotten Password to Unprotect Workbook/sheet

If the allinternalpasswords.xls file is based on the code at J.E. McGimpsey's
site:
http://mcgimpsey.com/excel/removepwords.html

Then this will break the passwords set by:
tools|protection|protect worksheet
or
tools|Protection|protect workbook

It won't break the passwords applied via:
file|Saveas|Tools...
or passwords to the VBA project.

But J.E. does have some notes that may point you in the right direction for this
level of protection:
http://mcgimpsey.com/excel/fileandvbapwords.html



alankeno wrote:

Hello All,

I've inheirited some workbooks that to my displeasure are passworded.
The original owner doesn't remember the passwords.
I've downloaded allinternalpasswords.xls but don't know how that's
supposed to work.
I've downloaded and "added in" password.xla, but when I try to open the
passworded workbook I get nowhere. It says that the workbook is
unprotected, but it's not.

Any help will be greatly appreciated!

Alan

--
alankeno
------------------------------------------------------------------------
alankeno's Profile: http://www.excelforum.com/member.php...o&userid=28397
View this thread: http://www.excelforum.com/showthread...hreadid=349207


--

Dave Peterson