You cannot use a custom Help file for a VBA project in Excel 2007

Article translations Article translations
Article ID: 933557 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

Consider the following scenario. In Microsoft Office Excel 2007, you use a custom Help file for a Microsoft Visual Basic for Applications (VBA) project. In the VBA project, you try to open the custom Help file. To do this, you click the Help button on the title bar of a UserForm, and then you click the background of the UserForm. In this scenario, the VBA Help file appears instead of the custom Help file.

WORKAROUND

To work around this problem, follow these steps:
  1. Open the UserForm in the VBA project.
  2. Add a command button control to the UserForm.
  3. Double-click the command button, and then add the following code:
    Application.Help "FilePath\HelpFile.chm"
    Note HelpFile.chm is the custom Help file that you want to use in the VBA project.

STATUS

Microsoft has confirmed that this is a problem in Microsoft Office Excel 2007.


Properties

Article ID: 933557 - Last Review: September 19, 2011 - Revision: 4.0
APPLIES TO
  • Microsoft Office Excel 2007
Keywords: 
kbtshoot kbexpertisebeginner kbprb KB933557

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com