Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. BeforeClose event is used to delete a custom menu
Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Dim cbWSMenuBar As CommandBar
    On Error Resume Next
    Set cbWSMenuBar = Application.CommandBars("Worksheet menu bar")
    cbWSMenuBar.Controls("MrExcel Programs").Delete
End Sub