|
发表于 2011-1-13 15:27
|
显示全部楼层
本楼为最佳答案
本帖最后由 mxg825 于 2011-1-13 15:58 编辑
Private Sub CheckBox1_Click()
Range("J:K,X:Y,AL:AM,AZ:BA").EntireColumn.Hidden = Not (CheckBox1.Value)
End Sub
Private Sub CheckBox2_Click()
Range("L:M,Z:AA,AN:AO,BB:BC").EntireColumn.Hidden = Not (CheckBox2.Value)
End Sub
Private Sub CheckBox3_Click()
Range("P:Q,AD:AE,AR:AS,BF:BG").EntireColumn.Hidden = Not (CheckBox3.Value)
End Sub
Private Sub CheckBox4_Click()
Range("T:U,AH:AI,AV:AW,BJ:BK").EntireColumn.Hidden = Not (CheckBox4.Value)
End Sub
Private Sub UserForm_Activate()
CheckBox1.Value = Not (Range("J:J").EntireColumn.Hidden)
CheckBox2.Value = Not (Range("L:L").EntireColumn.Hidden)
CheckBox3.Value = Not (Range("P:P").EntireColumn.Hidden)
CheckBox4.Value = Not (Range("T:T").EntireColumn.Hidden)
End Sub
多谢楼下提醒,, 附件的代码未加 NOT()
|
|