用PrePareEdit事件:
If e.Col.Name = "B列名称" Then
If e.Row("A列名称") = “男” Then
e.Cancel =True
End If
参考:
http://www.foxtable.com/help/topics/0605.htm