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
- Oct 22 Sun 2006 20:10
custom menu
close
全站熱搜
留言列表
發表留言