VBA自定义的菜单,卸载后菜单无法消除

2025-03-17 15:52:48
推荐回答(1个)
回答1:

增加一个文件关闭时的事件,放在Thisworkbook

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("Data").Controls.Reset
End Sub