View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tom taol tom taol is offline
external usenet poster
 
Posts: 52
Default making toggle button in xl menu



i need to method making the xl menu button of toggle button type using
macro(vba).
here is the code, it does not working.

Set oMenu = Application.CommandBars(1). _
Controls.Add(Type:=msoControlButtonToggle, Befo=1)
With oMenu
.Caption = "test"
.Style = msoButtonIconAndCaptionBelow
.BeginGroup = True
End With


*** Sent via Developersdex http://www.developersdex.com ***