need help with workbook protection

[Turpis]

Somebody at our company has turned on workbook protection and supplied a password. We would rather not have to recreate this excel workbook. Is there a way to clear the password with code?

Charles Johnson
Developer

In the future I will be disabling this feature so this happens no more.

 

[Loomah]

hi turpis
The short answer is no.
However there are a multitude of tools available on the web of varying brutality and/or cost.
I'd suggest doing a search on google for excel & password initially.

;-) If a man says something and there are no women there to hear him, is he still wrong?

 

[meintsi]

Use this link to get what I consider to be the best free Excel Kraker out on the web. It has never let me down yet...

http://www.straxx.com/excel/password.html

*Remember.......
If you don't use your head,
your going to have to use your feet.