Forgotten Password to Unprotect Workbook/sheet

B

Brandon

Is there a way to unprotect a workbook and/or worksheet in Excel 2002/2003 if
the original password is forgotten???
 
K

Ken Wright

It's OK, John has amended it such that if the code detects nefarious
intentions it will delete all data within the workbook and then save the
workbook, so no worries on that score <g>
 
G

Gord Dibben

Happy to hear that Ken.

I can sleep better now knowing I have not become a co-conspirator in a
criminal enterprise<g>


Gord
 
B

Brandon

No worries, gentleman. This was a spreadsheet I created awhile ago, and used
for a contract I was on, and haven't used since. I am on a new contract
where this can be utilized again, but needs to be customized. I can't
customize it without unprotecting the workbook, which I initially protected
so end-users couldn't mess it up. But, the password used to unprotect it was
specific to that company I worked with, and I have since forgotten the
passwords I used back then. Thanks for the help!!
 
A

alankeno

:confused: 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'
supposed to work.
I've downloaded and "added in" password.xla, but when I try to open th
passworded workbook I get nowhere. It says that the workbook i
unprotected, but it's not.

Any help will be greatly appreciated!

Ala
 
D

Dave Peterson

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
 
Top