Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

User Defined help files

Status
Not open for further replies.

Molby

Technical User
May 15, 2003
520
GB
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?
 
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
 
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?
 
Gerry,

If I try:
Code:
'Application.HELP "MYHELPFILENAMEANDPATH.chm"
Then the help file hangs.
Else I do
Code:
filenam = "MYHELPFILENAMEANDPATH.chm"
ActiveWorkbook.FollowHyperlink Address:=filenam
And I get the warning message.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top