Rss & SiteMap
Foxtable(狐表) http://www.foxtable.com
If User.Name = "路人甲" Then
Tables("表A").Visible = False
End If
If User.Name = "路人甲" Then
Tables("表B").Visible = False
End If
If User.Name = "路人甲" Then
Tables("表C").Visible = False
End If
If User.Name = "路人乙" Then
Tables("表A").Visible = False
End If
If User.Name = "路人乙" Then
Tables("表B").Visible = False
End If
有没有高手指教一下?
如果项目里面的表很多,用户也很多的话.这个表达式就很复杂了.
Tables("表A").Visible = not(User.Name = "路人甲" or User.Name = "路人乙")
Tables("表B").Visible = not(User.Name = "路人甲" or User.Name = "路人乙")
Tables("表C").Visible = not(User.Name = "路人甲" )