ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Worksheet Password Recovery (https://www.excelbanter.com/excel-programming/282423-worksheet-password-recovery.html)

bob

Worksheet Password Recovery
 
Hi all,

Does anybody know the best way to write a macro that will
recover the password for a worksheet ?.

I am told that the security for this is weak and therefore
writing a program to access this is simple .

However, how is this different from writing any other
program to recovery a password (length undetermined) .
Afterall standard techniques would apply (e.g brute force,
dictionary methods etc..), so how is this easier for a
worksheet ?.

Also, I have a program that recovers VBA passwords from
Excel workbooks but I have no idea how it does this !??
But it does so instantly without fuss (excel versions
XP,2000,95). Can somebody explain how ?.

Any help on this, would be appreaciated.

Many thanks,



TonyM

Worksheet Password Recovery
 
You only need access to the vba editor to 'unprotect' a
worksheet without knowing the password. Highlight the
worksheet in the VBA project pane, then change the visible
property to xlSheetVisible in the Properties pane. You can
then reset the password to whatever you want. Don't know
why you would wish to recover the existing password itself
though.

-----Original Message-----
Hi all,

Does anybody know the best way to write a macro that will
recover the password for a worksheet ?.

I am told that the security for this is weak and

therefore
writing a program to access this is simple .

However, how is this different from writing any other
program to recovery a password (length undetermined) .
Afterall standard techniques would apply (e.g brute

force,
dictionary methods etc..), so how is this easier for a
worksheet ?.

Also, I have a program that recovers VBA passwords from
Excel workbooks but I have no idea how it does this !??
But it does so instantly without fuss (excel versions
XP,2000,95). Can somebody explain how ?.

Any help on this, would be appreaciated.

Many thanks,


.


TonyM

Worksheet Password Recovery
 
Having a brainstorm - forget what I posted previously! Not
true.


-----Original Message-----
You only need access to the vba editor to 'unprotect' a
worksheet without knowing the password. Highlight the
worksheet in the VBA project pane, then change the

visible
property to xlSheetVisible in the Properties pane. You

can
then reset the password to whatever you want. Don't know
why you would wish to recover the existing password

itself
though.

-----Original Message-----
Hi all,

Does anybody know the best way to write a macro that

will
recover the password for a worksheet ?.

I am told that the security for this is weak and

therefore
writing a program to access this is simple .

However, how is this different from writing any other
program to recovery a password (length undetermined) .
Afterall standard techniques would apply (e.g brute

force,
dictionary methods etc..), so how is this easier for a
worksheet ?.

Also, I have a program that recovers VBA passwords from
Excel workbooks but I have no idea how it does this !??
But it does so instantly without fuss (excel versions
XP,2000,95). Can somebody explain how ?.

Any help on this, would be appreaciated.

Many thanks,


.

.


Kevin

Worksheet Password Recovery
 
"Bob" wrote in message ...
Hi all,

Does anybody know the best way to write a macro that will
recover the password for a worksheet ?.

I am told that the security for this is weak and therefore
writing a program to access this is simple .

However, how is this different from writing any other
program to recovery a password (length undetermined) .
Afterall standard techniques would apply (e.g brute force,
dictionary methods etc..), so how is this easier for a
worksheet ?.

Also, I have a program that recovers VBA passwords from
Excel workbooks but I have no idea how it does this !??
But it does so instantly without fuss (excel versions
XP,2000,95). Can somebody explain how ?.

Any help on this, would be appreaciated.

Many thanks,


AFAK, the standard encryption is idd weak. However they now have
stonger rc4(128 bits) encryption. The best way to understand these
encryptions is to first check how they work.
http://www.ncat.edu/~grogans/algorit...riptio.htm(for
the rc4 algorithm or streaming algorithm)

J.E. McGimpsey

Worksheet Password Recovery
 
Take a look he

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

In article ,
"Bob" wrote:

Hi all,

Does anybody know the best way to write a macro that will
recover the password for a worksheet ?.

I am told that the security for this is weak and therefore
writing a program to access this is simple .

However, how is this different from writing any other
program to recovery a password (length undetermined) .
Afterall standard techniques would apply (e.g brute force,
dictionary methods etc..), so how is this easier for a
worksheet ?.

Also, I have a program that recovers VBA passwords from
Excel workbooks but I have no idea how it does this !??
But it does so instantly without fuss (excel versions
XP,2000,95). Can somebody explain how ?.

Any help on this, would be appreaciated.

Many thanks,



bob

Worksheet Password Recovery
 

I have done this bit through the VBA editor, and unhidden
the worksheet. What I can't do is unhide the columns on
this worksheet as the 'unhide' option is disabled - which
means it probably still needs me to enter a password.

Please advise ,

Many thanks,



-----Original Message-----
You only need access to the vba editor to 'unprotect' a
worksheet without knowing the password. Highlight the
worksheet in the VBA project pane, then change the

visible
property to xlSheetVisible in the Properties pane. You

can
then reset the password to whatever you want. Don't know
why you would wish to recover the existing password

itself
though.

-----Original Message-----
Hi all,

Does anybody know the best way to write a macro that

will
recover the password for a worksheet ?.

I am told that the security for this is weak and

therefore
writing a program to access this is simple .

However, how is this different from writing any other
program to recovery a password (length undetermined) .
Afterall standard techniques would apply (e.g brute

force,
dictionary methods etc..), so how is this easier for a
worksheet ?.

Also, I have a program that recovers VBA passwords from
Excel workbooks but I have no idea how it does this !??
But it does so instantly without fuss (excel versions
XP,2000,95). Can somebody explain how ?.

Any help on this, would be appreaciated.

Many thanks,


.

.



All times are GMT +1. The time now is 11:39 PM.

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