[Billy]

I have inherited a workbook from and employee that has left the company. The
workbook has one of the worksheets password protected. Is there a way to
remove the protection without knowing the password?

[Don]

yes, look on the web, I downloaded a macro that will unlock any
workbook/worksheet. I got the link from this disussion group, so it is here
somewhere.



"billy" wrote:

I have inherited a workbook from and employee that has left the company. The
workbook has one of the worksheets password protected. Is there a way to
remove the protection without knowing the password?

[Billy]

Thanks Don. Found it, worked like a charm.

"Don" wrote:

yes, look on the web, I downloaded a macro that will unlock any
workbook/worksheet. I got the link from this disussion group, so it is here
somewhere.



"billy" wrote:

I have inherited a workbook from and employee that has left the company. The
workbook has one of the worksheets password protected. Is there a way to
remove the protection without knowing the password?

[Don]

yes, not that hard to figure out which shows how secure a file is if you
password protect.

good luck

"billy" wrote:

Thanks Don. Found it, worked like a charm.

"Don" wrote:

yes, look on the web, I downloaded a macro that will unlock any
workbook/worksheet. I got the link from this disussion group, so it is here
somewhere.



"billy" wrote:

I have inherited a workbook from and employee that has left the company. The
workbook has one of the worksheets password protected. Is there a way to
remove the protection without knowing the password?

[KDG]

Yaaa!!!! I NEED this macro, too!!! I've searched and have yet to find it...
sometimes my search skills are not as good as they should be... Could you
tell me exactly where to find it, or give me the macro!?!?? I am in
extreeeeeeme need of it!!!! I thank you for your expedient response!!!

"Don" wrote:

yes, look on the web, I downloaded a macro that will unlock any
workbook/worksheet. I got the link from this disussion group, so it is here
somewhere.



"billy" wrote:

I have inherited a workbook from and employee that has left the company. The
workbook has one of the worksheets password protected. Is there a way to
remove the protection without knowing the password?

[KDG]

YES!!! I really need this, too! Can you let me know where you found it!?!?!?!

Thanks!!!

"billy" wrote:

Thanks Don. Found it, worked like a charm.

"Don" wrote:

yes, look on the web, I downloaded a macro that will unlock any
workbook/worksheet. I got the link from this disussion group, so it is here
somewhere.



"billy" wrote:

I have inherited a workbook from and employee that has left the company. The
workbook has one of the worksheets password protected. Is there a way to
remove the protection without knowing the password?

[Gord Dibben]

A macro can be found at John McGimpsey's site.

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


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 06:25:02 -0700, KDG
wrote:

YES!!! I really need this, too! Can you let me know where you found it!?!?!?!

Thanks!!!

"billy" wrote:

Thanks Don. Found it, worked like a charm.

"Don" wrote:

yes, look on the web, I downloaded a macro that will unlock any
workbook/worksheet. I got the link from this disussion group, so it is here
somewhere.



"billy" wrote:

I have inherited a workbook from and employee that has left the company. The
workbook has one of the worksheets password protected. Is there a way to
remove the protection without knowing the password?

[Dave Peterson]

Visit JE McGimpsey's site:
http://mcgimpsey.com/excel/removepwords.html

KDG wrote:

YES!!! I really need this, too! Can you let me know where you found it!?!?!?!

Thanks!!!

"billy" wrote:

Thanks Don. Found it, worked like a charm.

"Don" wrote:

yes, look on the web, I downloaded a macro that will unlock any
workbook/worksheet. I got the link from this disussion group, so it is here
somewhere.



"billy" wrote:

I have inherited a workbook from and employee that has left the company. The
workbook has one of the worksheets password protected. Is there a way to
remove the protection without knowing the password?

--

Dave Peterson