Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!swrinde!cs.utexas.edu!sun-barr!apple!robg
From: robg@Apple.COM (Rob Griffiths)
Newsgroups: comp.sys.mac.apps
Subject: MS Excel 2.2 Macro sheet
Keywords: how to unprotect?
Message-ID: <50412@apple.Apple.COM>
Date: 18 Mar 91 23:57:23 GMT
Organization: Apple Computer Inc., Cupertino, CA
Lines: 17

A while back, we had a contractor create a consolidation macro in Excel.
For whatever reason, the creator decided to protect the macro sheet with
a password, using Options Protect Document.

This happened before I started work here.  Now, of course, I have been given
the task of updating the macro.  And the departed contractor did not leave
the password anywhere!

So, the question is, can I unprotect the macro sheet somehow?  Or must I
print out the formulas, and re-create the sheet from scratch?  I've tried
the obvious trick of selecting the whole macro sheet, copying it, and
pasting it into a new macro sheet.  This removes the protection, but it
also converts all the macro code into boolean results!  ie, a line which
used to read "=FORMULA.GOTO(!area_name)" now reads "TRUE".

Any help appreciated!
-rob.