PDA

View Full Version : Excel password



jat421
03-22-2005, 11:15 AM
Hi guys,

I have a spreadsheet that is password proteted and I know the password. But for some reason when I go to tools > protection menu. I can only click on protect shared work. But the other two options I can't click are "Unprotect workbook" and "Unprotect sheet". So how can I click on thes options? Please help

Thanks

ober
03-22-2005, 11:49 AM
Are you "logged in" to the workbook?

jat421
03-22-2005, 11:53 AM
yes logged in and before I could go into tools > protection and unlock the sheet and workbook, but for some reason I can't now. Any idea what could be wrong?

Thanks

jat421
03-22-2005, 11:56 AM
oh I got it :), I had to unshare it before I could unlock the sheets :). Thanks anyways guys :)