password protected worksheet

[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]

Thanks Don. Found it, worked like a charm.

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.

 

[Don]

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

good luck

 

[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!!!

 

[KDG]

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

Thanks!!!

 

[Gord Dibben]

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

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


Gord Dibben MS Excel MVP

 

[Dave Peterson]

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