Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Harley Evans   on Jan 11 In MS Office Category.

  
Question Answered By: Kenny Moore   on Jan 11

Do you mean a "classic" Windows help  file? Microsoft is encouraging developers
to switch to HTML-based help instead. I used to use Visual Help Pro to create
Help files. RoboHelp is probably the cream of the help compiler crop. I don't
know of any freeware.

Let me give you two alternatives for providing help in excel  applications.
John Walkenbach has a nice flexible userform for displaying help text. You can
read about it and even download a free  working copy at his website:

http://www.j-walk.com/ss/excel/tips/tip51.htm

I usually just put my help text on another sheet in the workbook. I have a
command button on the userform (or worksheet) that moves to the help sheet and
displays it full screen:

'Userform frmMain has a command button cmdHelp
Private Sub cmdHelp_Click()
Me.Hide 'or Unload Me
ActiveWorkbook.Sheets("Help 1").Activate
ActiveWindow.Zoom = 100
Application.DisplayFullScreen = True
Cells(1, 1).Select
End Sub

On the help sheet, I have a "Close Help" button at the top next to a heading.
Freezing panes beneath the heading keeps the button always in view. By turning
gridlines off and displaying full screen, I have a big, blank space in which to
put my help. The help
can include formatted text, WordArt, graphics, screen captures, audio clips,
etc. It's a lot easier to maintain than a separate Help file.

'Close Help command button on sheet "Help 1" sends user
'back to correct sheet and re-displays frmMain.
Private Sub cmdHelp1_Click()
On Error Resume Next
ActiveWorkbook.Sheets("Sheet1").Activate
Application.DisplayFullScreen = False
frmMain.Show
End Sub

Share: 

 
 
Didn't find what you were looking for? Find more on how to make a help file for a project? Or get search suggestion and latest updates.


Tagged: