Julia has attended:
Excel Intermediate course
Removing a password
How do I remove a password from a password protected excel sheet so I can open without it?
RE: Removing a password
Hi Julia, Thanks for the question, in answer to it:
If you wish to remove a password from your worksheet you first have to know it!!!!
Open the worksheet using the password, then go to the menu command Tools>Protection>Unprotect Sheet, you will be presented with a little box to enter the password again, now you can close the worksheet and re-open it without requiring a password validation.
regards Pete
.
RE: Removing a password
Thanks, Pete.
I did that that but it just unprotected the cells (didn't want to do that) - it didn't remove the password. I still needed to use it to open the sheet, I tried it several times.
Cheers,
Julia
RE: Removing a password
Hi Julia,OK I guess you have the entire workbook protected, this requires you to enter a password before the book even opens (am I right?) if this is the case, you should open the file with your password, look in Tool>Options and under the Security tab, clear the boxes of any asterix that may be there, save the workbook, this should remove the security password. I hope it helps this time, regards Pete
