G
Guest
Is there a way to unprotect a workbook and/or worksheet in Excel 2002/2003 if
the original password is forgotten???
the original password is forgotten???
D
Dave Peterson
Visit JE McGimpsey's site:
http://mcgimpsey.com/excel/removepwords.html
http://mcgimpsey.com/excel/removepwords.html
G
Gord Dibben
See John McGimpsey's site for info and methods.
http://www.mcgimpsey.com/excel/removepwords.html
But you must promise us you are not doing this for nefarious reasons.
Gord Dibben Excel MVP
http://www.mcgimpsey.com/excel/removepwords.html
But you must promise us you are not doing this for nefarious reasons.
Gord Dibben Excel MVP
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>
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
I can sleep better now knowing I have not become a co-conspirator in a
criminal enterprise<g>
Gord
G
Guest
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!!
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!!
K
Ken Wright
LOL - Pay us no mind Brandon, and i'm assuming you got sorted yes?
G
Gord Dibben
Brandon
Just pulling your padonger as Ken points out.
Gord Dibben Excel MVP
Just pulling your padonger as Ken points out.
Gord Dibben Excel MVP
A
alankeno
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
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