D
David
Folks,
I am using the HTML Help Workshop to create custom help files of the
..chm variety. I am including context IDs in the file, and it is our
hope to be able to call the custom help file from custom VBA functions
and Add-ins in Excel 2000. The following is an example of what I
might want to do:
--------------------
Option Explicit
--------------------
Public Function AddTwo(c As Double, d As Double) As Double
'Application.Assistant.Visible = False
Application.Help ActiveWorkbook.Path & "\HelpFile.chm", 2001
AddTwo = c + d
End Function
--------------------
Public Function SubtractTwo(c As Double, d As Double) As Double
'Application.Assistant.Visible = False
Application.Help ActiveWorkbook.Path & "\HelpFile.chm", 3001
SubtractTwo = c - d
End Function
--------------------
I am setting the help file in the project properties with a context ID
of 1001 (the default page.) When I input our custom functions from
the formula palette and choose the question mark button, the office
assistant fires (attempting to lock him/her out has proven pointless
to date!) If I choose "Help with this feature" and then "Help on
selected function" then wew get the default page of our help file -
the one for the project with context ID 1001. Obviously, we would
like to pull up the page with the context ID associated directly with
the function, i.e. context ID 2001 or context ID 3001 depending.
In addition, I am having difficulty getting my custom help file to
fire at all when my code is stored in an add-in. Is there a secret to
referencing a custom help file that will allow me to access my
preferred potions based on context ID from an add-in?
Thanks for your help, everyone.
David
I am using the HTML Help Workshop to create custom help files of the
..chm variety. I am including context IDs in the file, and it is our
hope to be able to call the custom help file from custom VBA functions
and Add-ins in Excel 2000. The following is an example of what I
might want to do:
--------------------
Option Explicit
--------------------
Public Function AddTwo(c As Double, d As Double) As Double
'Application.Assistant.Visible = False
Application.Help ActiveWorkbook.Path & "\HelpFile.chm", 2001
AddTwo = c + d
End Function
--------------------
Public Function SubtractTwo(c As Double, d As Double) As Double
'Application.Assistant.Visible = False
Application.Help ActiveWorkbook.Path & "\HelpFile.chm", 3001
SubtractTwo = c - d
End Function
--------------------
I am setting the help file in the project properties with a context ID
of 1001 (the default page.) When I input our custom functions from
the formula palette and choose the question mark button, the office
assistant fires (attempting to lock him/her out has proven pointless
to date!) If I choose "Help with this feature" and then "Help on
selected function" then wew get the default page of our help file -
the one for the project with context ID 1001. Obviously, we would
like to pull up the page with the context ID associated directly with
the function, i.e. context ID 2001 or context ID 3001 depending.
In addition, I am having difficulty getting my custom help file to
fire at all when my code is stored in an add-in. Is there a secret to
referencing a custom help file that will allow me to access my
preferred potions based on context ID from an add-in?
Thanks for your help, everyone.
David