View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
helmekki[_93_] helmekki[_93_] is offline
external usenet poster
 
Posts: 1
Default Two menus appears in commandbar(Cells)


Hi there
i have a problem,
when openning the XL App, two menus should be added to th
Commandbar(Cells) :
one is:

Code
-------------------
Set ComPop = Application.CommandBars("Cell").Controls.Add(Type: =msoControlPopup, befo=10)
ComPop.BeginGroup = True
ComPop.Caption = "&Favourites
-------------------

Second is:

Code
-------------------
With Application.CommandBars("cell").Controls.Add(befor e:=1, Type:=msoControlPopup)
.Caption = "Gold Menu"
End Wit
-------------------


The problme is that one appears in the comaandbar(cells) but hte othe
not, i tried to modify the argument befo=1 or 2 or even 9, bu
without success, both togather never appear in the commandbar(cells).
i need them both to be appear in the commandbar(Cells)

--
helmekk

-----------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...nfo&userid=693
View this thread: http://www.excelforum.com/showthread.php?threadid=39526