Try something like this

Application.MacroOptions Macro:="CalcSeqCountRef", Description:="Calculation
sequence counter for the referenced cell", Category:=9,
HelpFile:=ThisWorkbook.Path & "\FastExcelUser2.hlp", HelpContextID:=309

If that does not work there is also a much more complex and troublesome
method using XLM macros & hidden namespaces etc (I have just spent 4 days
getting it to work....)

regards
Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

"Jsadleir" wrote in message
...
Hi Coders

I have written a series of vba functions and I want to provide
context-sensitive help for each of these functions from the help file
hyperlink on the function wizard. Using HelpScribble
(www.helpscribble.com) I
was able to put together a .hlp help file and load the right help file
page
for each individual function. (I used a .hlp file rather than the newer
.chm
files because the .chm would never load properly).

My problem is that with some earlier versions of Excel (well Excel 2000
9.0)
I can only find the .hlp file if I manually unlock the VBA password
protection, go to the VBA Project's properties and click on the ... button
to
direct Excel to the .hlp file. I have tried saving the .hlp file in many
different folders (windows, office, library etc) but have not found a
folder
that Excel defaults to when looking for help files. I have tried entering
an
absolute path in the Help File field but that does not work either.

Is there a way to do this programmatically through VBA (ie tell the VBA
project where the help file is)?

I am able to find the path to the help files using SHGetFolderPath
(Shell32)
and can call a particular help topic with WinHelp (user32), but neither of
those API calls are useful if I can't detect from the VBA project the
click
event that occurs when the function wizard hyperlink is clicked.

Any thoughts or suggestions would be much appreciated.

Regards

Jeremy