Old Excel doc + PW Protection

[Martin René]

Hello everyone,

I am trying to open an old Excel document (was probably written with Excel 4
or 5) in Excel for OS X, that have password protection on (Excel ask for a
password everytime I open it, and of course I know the Password). I want to
take the PW off, so I click on the Tools menu + Protection... But Unprotect
option is not available, like if the Protection feature was never activated.
Is there a way to disable this using a utiltysoft like BBEdit or something
else.

Thanks

Martin

 

[Jim Gordon]

Hi

There is more than one place to protect an Excel workbook. In your case, it
is the file that is protected rather than the worksheet. The fix for you is
to open the workbook. Then, from the File menu, choose Save As and click the
Options button. Clear the checkmarks concerning saving and remove the
password, save the file and your troubles will all disappear. If only life's
other troubles were so easy to solve.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

 

[Martin René]

Thanks a lot Jim,

I've always thought that the "Protection" option from the tools menu and
from the Option in the save window was the same thing. It never crossed my
mind to look there.
Well life IS simple... I've just found another way complicated it a little.

Thanks again

Martin