View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Add-In Adding to Help File?

Hi Matthew

The below will take you in the right direction...You can try the below code
to initiate in open event..which will identify the Help Control and add a new
button named "New Help" and assign that to a Macro which exists in the
add-in. Try and feedback


Dim cbMainMenuBar As CommandBar
Dim cbcCutomMenu As CommandBarControl

Set cbMainMenuBar = Application.CommandBars("Worksheet Menu Bar")
Set cbcCutomMenu = cbMainMenuBar.Controls("Help")
With cbcCutomMenu.Controls.Add(Type:=msoControlButton)
.Caption = "New Help"
.OnAction = "Macro1"
End With


If this post helps click Yes
---------------
Jacob Skaria


"Matthew Wieder" wrote:

Hi - is there a way to add a new section to the Microsoft Excel help? We
have an Add-In and want the users to be able to bring up help for using it
inside of Excel. Is there a way to merge into that file programatically?