UnprotectWorkbook() yields index out of range under multiple conditions

Apr 10 at 12:25 PM

I have an .xls file with a single tab and a contiguous block of cells with no nulls. I have made sure there are no extraneous empty rows or columns trailing my data. The UnprotectWorkbook() function yields index out of range on its list of records regardless, on a sheet that is known to be protected. The User Model only includes UnprotectWorkbook, not sheet or record.

Can anyone help? Thank you!
  • Theresa
Apr 10 at 12:39 PM
More on this:

The library is reporting that the Workbook is not write protected to begin with once queried by the code, but the individual sheets as viewed in Excel are clearly password protected. In the User Model, I do not see an UnprotectSheet or Cell, only Workbook. Can someone tell me what I am doing wrong? Thanks!