password protected worksheet
 

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?

password protected worksheet
 

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?

password protected worksheet
 

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?

password protected worksheet
 

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?

password protected worksheet
 

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?

password protected worksheet
 

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?

password protected worksheet
 

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?

password protected worksheet
 

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