Read only or write protect for the cell

[MaxChan]

Dear Axolot,

How to make the cell readonly or write protect? Not allow user to change the value of specif cell.

best regards,
Max

[larsa]

Hello

Use the OnEditorOpen event. This is fired when the inplace editor is opened.

Example

Code: Select all

  if (FXSS.XLSSheet.SelectedAreas.First.Col1 = 2) and (FXSS.XLSSheet.SelectedAreas.First.Row1 = 2) then
    Value := False;

[MaxChan]

Got it, Thank you very much!