custom menu

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?
 
E

ExcelPower

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top