Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unprotect Excel Spreadsheet? 1

Status
Not open for further replies.

Doris

MIS
Sep 25, 2000
9
US
Does anyone know of a way to unprotect an Excel spreadsheet (Office 2000)?

Thanks!
 
hi,

tools/protection/unprotect

Skip,
[sub]
[glasses] [red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!
[tongue][/sub]
 
Sorry, the user that protected it has left the company and no one has the password.
 
If you just need data from the worksheet, you can copy all cells and paste into a new workbook.

Beyond that, we can't help you crack the password protection. But if you do an internet search you'll find several commercial options and at least one free macro that's been posted on other boards.

[tt]-John[/tt]
________________________
To get the best answers fast, please read faq181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top