Hi, I'm using the following code to remove my custom Menu-Items when closing the file.
On testing the removal code is working, however in the daily usage the Customs Items sometime stay with Excel (Opening Excel with no file would show those items). I couldn't find the actual steps which would not run the removal code.
Am I using the wrong Event?
Code:Private Sub Workbook_BeforeClose(Cancel As Boolean) Dim Text As String On Error Resume Next Text = "TG" Application.CommandBars("Worksheet Menu Bar").Controls(Text).Delete Text = "RBH" Application.CommandBars("Worksheet Menu Bar").Controls(Text).Delete End Sub




Reply With Quote