how do I unprotect a workbook in excel 2000?

6 ⤊

how do I unprotect a workbook in excel 2000?

2007-03-05 23:23:09 · 3 answers · asked by CR 1 in Computers & Internet ➔ Software

3 answers

Go to tools, then 'unprotect' then enter the password you used to protect it.

Edit: That's what I do in 2003. In earlier versions, I think you have to go to format, then under the style option, it should offer you the protection option.

Good luck.

2007-03-05 23:27:04 · answer #1 · answered by RM 6 · 2⤊ 0⤋

go to TOOLS / PROTECTION / UNPROTECT SHEET

you may need a password if one was created when the sheet was protected

If the whole file is protected you'll need the password from the creator.

2007-03-05 23:27:11 · answer #2 · answered by funkysuze 3 · 2⤊ 0⤋

Go to:

Tools
Protection
Unprotect Workbook
Enter password is there was one, else leave blank

2007-03-05 23:26:51 · answer #3 · answered by Marky 6 · 2⤊ 0⤋