User Defined help files

[Molby]

Using Excel XP.
I've created my own '.chm' help file for an Excel Application I've created. I want the help file to be available when the user presses F1, rather than the default Excel help file. I've assigned the file under the 'Help File Name' in Project Properties in the VBE window, but it doesn't seem to do anything. Most of the time the users will be using a Userform that has links to other applications.

Any suggestions?

 

[Molby]

Anyone, any ideas at all?

 

[fumei]

Custom help should respond to Shift-F1.

You could also rewrite the Help command itself.

Sub Help()
' overrides F1
' call custom help files
End Sub

Gerry

 

[Molby]

Gerry,

I don't think I'm doing something right here, if I use shift F1, it looks like Excel is trying to bring up help, but it just hangs, and eventually I get an 'Out of Memory' message. I've also tried using 'Application.HELP', and then the name of my help file in my code, but the same thing happens.
Also if I try to link directly to the file via a user defined button I get a warning message saying 'Some files can contain viruses or otherwise be halmful to your computer'. I've tried application.displayalerts = False, but this has no effect.

Any idea what could be wrong?

 

[fumei]

Could you post some code?

Gerry

 

[Molby]

Gerry,

If I try:

'Application.HELP "MYHELPFILENAMEANDPATH.chm"

Then the help file hangs.
Else I do

filenam = "MYHELPFILENAMEANDPATH.chm"
ActiveWorkbook.FollowHyperlink Address:=filenam

And I get the warning message.