Message-ID: <2141004541.9019.1711672450210.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_9018_1253582173.1711672450210" ------=_Part_9018_1253582173.1711672450210 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Sets or returns whether the worksheet will allow users to select unlocke= d cells when the worksheet is protected.
=20public boolean AllowSelectUnlockedCells{ get; set; }=20
Public Property AllowSelectUnlockedCells() As Boolean=20
ExcelApplication xla =3D new ExcelApplication(); Workbook wb =3D xla.Open(@"C:\MySpreadsheet.xlsx"); Worksheet ws =3D wb.Worksheets[0]; ws.SheetProtection.AllowSelectUnlockedCells =3D true; ws.Protect("password");=20
Dim xla As New ExcelApplication() Dim wb As Workbook =3D xla.Open("C:\MySpreadsheet.xlsx"= ) Dim ws As Worksheet =3D wb.Worksheets(0) ws.SheetProtection.AllowSelectUnlockedCells =3D true ws.Protect("password");=20
false
will also set AllowSelectCells to=20
false
.