🚀 go-pugleaf

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.