How to Protect and unprotect sheets

Dec 7, 2011 at 6:21 AM

I have an excel workbook with 2 protected sheets and a few unprotected cells in each sheet where students can answer questions.

Is there a PS command to unprotect these worksheets. There is no password.

I tried $sheet1.unprotect, i get no error but the sheets stay protected.

It's hard to find a good Excel Powershell reference. Anyone who knows one?