custom menu

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

a custom menu (operated with some macro) always appears when I open the
workbook although I deleted it (or changed its name) before already. How can
I pernamently delete it?
 
Public Sub RemoveCustomMenu()
Dim cbWSMenuBar As CommandBar
On Error Resume Next
Set cbWSMenuBar = CommandBars("Worksheet Menu Bar")
cbWSMenuBar.Controls("Menu").Delete
End Sub
'*******************


"Menu" Is the Name of Menu at my place u can replace it by the name
given by u

with regards

Excel Power
 
Back
Top