直接调用,把其他三个按钮前的private去掉
Private Sub CommandButton1_Click()
MsgBox 1
Call Sheet2.CommandButton1_Click
Call Sheet3.CommandButton1_Click
Call Sheet4.CommandButton1_Click
End Sub
直接调用,把其他三个按钮前的private去掉
Private Sub CommandButton1_Click()
MsgBox 1
Call Sheet2.CommandButton1_Click
Call Sheet3.CommandButton1_Click
Call Sheet4.CommandButton1_Click
End Sub