Hi Folks,
I am working with Spread Designer 2.5, after a very long time.
I want to make a few cells in a specific column non editable.

I am populating the spread control from an array. This array has an element "approval_status". If the value of approval status is "Y", then the cell needs to be locked down. I tried using blockmode, but it is not working for me.

Code:
       spdApprovalList.Col = mnApprovalStatus
       spdApprovalList.CellType = SS_CELL_TYPE_CHECKBOX
       spdApprovalList.TypeCheckTextAlign = SS_CELL_H_ALIGN_RIGHT
       spdApprovalList.TypeCheckText = "Yes"
       spdApprovalList.BlockMode = True
       spdApprovalList.Row = ilIdx
       spdApprovalList.Row2 = ilIdx
       spdApprovalList.Col2 = mnApprovalStatus
       spdApprovalList.Lock = True
       spdApprovalList.Protect = True
       spdApprovalList.BlockMode = False
       If arrETApproval(ilIdx).Approval_Status = "Y" Then
            spdApprovalList.Col = mnApproveDate
            spdApprovalList.text = arrETApproval(ilIdx).Approval_Date
            spdApprovalList.Lock = True
            spdApprovalList.Protect = True
            spdApprovalList.Col = mnApprovedBy
            spdApprovalList.text = arrETApproval(ilIdx).Approved_By
            spdApprovalList.Lock = True
            spdApprovalList.Protect = True
       Else
            spdApprovalList.TypeCheckType = 0
            spdApprovalList.TypeCheckText = "No"
            spdApprovalList.Protect = False
       End If