Private Sub CommandButton1_Click()
With ActiveSheet.Shapes.Range(Array("Label1"))
.Visible = msoTrue '显示
Call test
.Visible = msoFalse '隐藏
End With
End Sub
'某个功能
Sub test()
Dim i
' For Each rg In Range("a1:n50000")
' rg = "实验"
' rg.Interior.Color = 15773696
' Next
For i = 1 To 10 ^ 5
VBA.DoEvents
Next i
End Sub
2.rar
(19.25 KB, 下载次数: 19)