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