excel表格怎么关闭vba宏

1.Excel VBA如何创建可撤销操作的宏

Sub BlaBla()

Application.OnRepeat "Repeat Procedure", "Repeat_Sub"

Application.OnUndo "Undo Procedure", "Undo_Sub"

End Sub

Sub Repeat_Sub()

Debug.Print "Repeat Here"

End Sub

Sub Undo_Sub()

Debug.Print "Undo Here"

End Sub