Lock a column in a datagrid

I have a datagrid in vb6.  When I pull up the records in the grid, I want to block the users from editing column 1,2 and 6.  How do I do this, if possible?

Who is Participating?
lppperesConnect With a Mentor Commented:
You can try using the event BeforeColUpdate. Check the ColIndex. If it is one of the forbbiden columns, cancel the update.

Private Sub DataGrid1_BeforeColUpdate(ByVal ColIndex as Integer, OldValue as Variant, Cancel as Integer)
    If ColIndex = 1 Or ColIndex = 2 Or ColIndex = 6 Then
        Cancel = 1
    End If
End Sub

Open in new window

Using the event BeforeColEdit you can achieve an user experience even better, cause the value in the column doesn´t get to change.
al4629740Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.