Foxtable(狐表)用户栏目专家坐堂 → 锁定行


  共有1843人关注过本帖平板打印复制链接

主题:锁定行

美女呀,离线,留言给我吧!
13775189031
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:四尾狐 帖子:804 积分:5548 威望:0 精华:0 注册:2017/12/19 14:46:00
锁定行  发帖心情 Post By:2019/3/20 17:53:00 [只看该作者]

startedit
Select Case e.Col.Name
    Case "幅面","零部件名称","零部件图号","图纸更改","生产令号","项目名称","建议更改","备注","编号","制单日期","编制","审核","批准","工程项目","版本状况_版本","图纸性质_自主设计","图纸性质_设计来图","图纸性质_来图转化","产品编号","图纸编号","版本状况_升版","签收人","签收日期","版本状况_升版原因","版本状况_状态","签收","分发人","回收","经办人","回收日期","电子版"
        Dim nms() As String = {"幅面","零部件名称","零部件图号","图纸更改","生产令号","项目名称","建议更改","备注","编号","制单日期","编制","审核","批准","工程项目","版本状况_版本","图纸性质_自主设计","图纸性质_设计来图","图纸性质_来图转化","产品编号","图纸编号","版本状况_升版","签收人","签收日期","版本状况_升版原因","版本状况_状态","签收","分发人","回收","经办人","回收日期","电子版"}
        For Each nm As String In nms
            If e.Row("回收") = True Then
                e.cancel = True
            End If
        Next
End Select

其中列“电子版”设置了扩展列类型为文件,但是其他列都可以锁定,只有“电子版”列无法锁定,还可以打开、另存、插入等,怎样能让此列也锁定后无法编辑
[此贴子已经被作者于2019/3/20 17:53:51编辑过]

 回到顶部