Message-ID: <1754355182.7671.1711617710796.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7670_426866766.1711617710796" ------=_Part_7670_426866766.1711617710796 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
.