robg@Apple.COM (Rob Griffiths) (03/19/91)
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.