whistler
Note: there are 3 types of Protection which can all be passworded.
1. WorkSheet protection from ToolsProtection
2. WorkBook protection from ToolsProtection
3. File protection from FileSave AsToolsGeneral Options(XL2002)
And a fourth one if you count Protection on a VBA Project
Which are you referring to?
If worksheet or workbook only, these are easy to crack.
File and VBA not so simple.
See John McGimpsey's site for instructions.
http://www.mcgimpsey.com/excel/removepwords.html
Gord Dibben Excel MVP
On Mon, 12 Dec 2005 08:18:02 -0800, "whistler_z"
wrote:
I have an older excel file created by someone who is no longer with my
company. I want to use that file as a starting point to created another
file. The file is set up as "read only". If I try to change any of the
cells, I get the message that the "cell or chart is protected and therefore
read only" and further tells me to unprotect before attempting the change.
When I got to tools/protection/Unprotect Sheet I get the request for a
password. I don't know the password as the file was created by another. I
have tried "save as", from tools making sure there are no passwords, and
created a file with a new name but the protection is still there! Help!