TXLSXProtectedRanges lets selected cells remain editable while worksheet protection is enabled
Declarations
function TXLSXProtectedRanges.Add(const AName, ASqref: WideString): TXLSXProtectedRange;
procedure TXLSXProtectedRanges.Clear;
property TXLSXProtectedRange.Name, Sqref, Password, SecurityDescriptor: WideString;
property TXLSXProtectedRanges.Items[Index: Integer]: TXLSXProtectedRange;
Key članovi
| Name | User-visible protected-range label |
| Sqref | One or more editable ranges in A1 notation |
| Password | Optional legacy Excel range password hash |
| SecurityDescriptor | Optional Windows security descriptor for the protected range |
Primjer
Sheet.ProtectedRanges.Add('Input cells', 'B2:B20 D2:D20');
Sheet.Protect;Vidi također