Datasheet

Figure 24-3: Configuring the Help window toolbar.

•

If you’re a VBA programmer, you can write a macro to display a particular help topic. To

do so, you need to know the topic ID. Locate the Help topic that you want to display,

and then right-click and choose Copy Topic ID. For example, the topic ID for the topic

Overview of Formulas is HP10081865. The following VBA procedure, when executed,

displays that Help topic:

Sub ShowFormulaOverview()

Application.Assistance.ShowHelp (“HP10081865”)

End Sub

NOTE

Unfortunately, displaying a Help topic by using VBA works only if the user’s Help system

is in Offline mode. If the user’s Help system is connected to Office Online, attempting to

display a Help topic shows only the opening screen. Unfortunately, VBA has no way to

determine which mode is being used.

Tip 24: Understanding the Excel Help System

Part I

04_137666 ch01.qxp 5/22/07 7:31 PM Page 63