close

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(quot;Worksheet Menu Barquot;)
cbWSMenuBar.Controls(quot;Menuquot;).Delete
End Sub
'*******************quot;Menuquot; Is the Name of Menu at my place u can replace it by the name
given by u

with regards

Excel Power--
ExcelPower
------------------------------------------------------------------------
ExcelPower's Profile: www.excelforum.com/member.php...oamp;userid=30964
View this thread: www.excelforum.com/showthread...hreadid=508847

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()