Sleeper: Cannot remove Open password from workbook

[Zack Barresse]

Hey Jake, have you tried it with a **** yet?

[Jacob Hilderbrand]

I haven't tried with a ****, but the file would be encrypted and it wouldn't be easy to un-encrypt it.

I guess there is really no way to tell what is causing this without moving every sheet, module, userform, and class module to a new workbook and testing one at a time. Given the size of the workbook this is no simple undertaking.

If I can figure out the actual cause I let you guys know. Thanks everyone for all the suggestions.

[Mike_R]

Wow, what a doozie...

Hmmm, yeah, the trouble could be in any one of the Worksheets, I guess. It may not be *that* simple, but assuming taht something is "attached" to one of them that is causing this, you might try a shot-gun approach:[vba]Sub Main()
Dim oSheet As Object

For Each oSheet In ThisWorkbook.Sheets
Call oSheet.SaveAs(Sheet.Name & ".xls")
Next Sheet
End Sub[/vba] Then you can open them all and see which (if any) complain.

If it's all of them, then I would save a new blank Worksheet as a Workbook and attach it here so we can kick it around... and/or infect our own computerrs.