/// <summary> /// Protège la feuille, sans mot de passe /// </summary> public bool ProtegerFeuille() { object Vrai = (object)true; object Faux = (object)false; try { _MaFeuille.Protect(_M, Vrai, Vrai, Vrai, _M, _M, _M, _M, _M, _M, _M, _M, _M, _M, _M, _M); return(true); } catch (Exception e) { MessageBox.Show(e.Message); return(false); } }
private void protect() { mSheet.Cells.Locked = false; if (this.DataList.Count > 0) { // only protect data cell, so if data is empty, ignore it Range startCell = mSheet.Cells[mStartRow + 2, mStartCol]; Range endCell = mSheet.Cells[mEndRow, mEndCol]; Range tableRange = mSheet.Range[startCell, endCell]; tableRange.Locked = true; } mSheet.Protect(Password, AllowFormattingCells: true, AllowFormattingColumns: true, AllowFormattingRows: true); }