- Foxtable(狐表) (http://foxtable.net/bbs/index.asp)
-- 专家坐堂 (http://foxtable.net/bbs/list.asp?boardid=2)
---- 锁定指定列和解锁指定列 (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=185322)
-- 发布时间：2023/2/16 15:19:00
-- 锁定指定列和解锁指定列
\'Dim Cols3() As String = {"立帐日期", "会计年月", "结算往来编码", "结算往来名称", "已付货款", "应付金额", "未付货款", "付款凭证", "立帐编码", "核销摘要", "简称", "年度", "制单", "审核", "子表行数", "应付差额", "发票核销"}
\'For Each c1 As Col = 0 To Cols3.Length - 1
\' c1.Visible = True
\' c1.AllowEdit = True
\'Next
锁定行不好操作，现在想审核列不为空时，就销定表的指定列；当需要操作指定列时，又进行解锁指定列，上面的代码该怎样写
-- 发布时间：2023/2/16 16:07:00
--
解锁：c1.AllowEdit = True
锁定：c1.AllowEdit = false
-- 发布时间：2023/2/16 16:27:00
--
此主题相关图片如下：qq截图20230216162624.png
-- 发布时间：2023/2/16 16:36:00
--
http://www.foxtable.com/webhelp/topics/0226.htm
For Each c1 As string in Cols3
tables("表A").cols(c1).AllowEdit = True