About getting help for spreadsheets
Some of the content in this topic may not be applicable to some languages.
Getting help in other design programs
When you are working in a design program, you can get help in the following ways:
- Design program Help For information about the commands and features available in the design program
that
you can use to work with spreadsheets, see Help in the design program. For example, in Microsoft FrontPage, click the Office Assistant, or click Microsoft FrontPage Help
.
Microsoft Excel provides both general Help about saving Excel data for use on Web pages, and specific information about saving spreadsheets for use on Web pages. To access this Help in Excel, click the Office Assistant, or click Microsoft Excel Help
.
- Spreadsheet design-time Help If you have access to the
Commands and Options dialog box in another design program, you have access to the Help topics you are viewing now. In a spreadsheet that you have created or activated in a design program, click Help
in the Commands and Options dialog box or click Help on the spreadsheet toolbar.
Getting help with writing scripts and programs that use spreadsheets
You can use scripts and programs to automate spreadsheets, or you can include spreadsheets in run-time programs other than Web browsers — programs that you develop in a programming environment such as Microsoft Visual Basic.
Writing scripts Microsoft Office programs provide the Microsoft Script Editor to help you write scripts. For example, you can use the Script Editor in Microsoft FrontPage to customize a spreadsheet. For information about running the Script Editor, see Help in your Office design program. In the Script Editor, you can display additional Help about using its features and writing scripts.
Object model Help For help developing a program or script to work with a spreadsheet, you can display information about the object model, properties, and methods specific to spreadsheets. This object model Help is installed whenever you install the Microsoft Office Web Components, of which the Spreadsheet Component is one. Depending on the design program you're using, you can access this Help in either of two ways:
- Help in Microsoft Visual Basic In Visual Basic or Visual Basic for Applications (VBA), you can create a reference to the Office Web Components library. You will then have access to Help through the object browser or by selecting a keyword and pressing F1. For information about creating references and using object model Help, see Help in Visual Basic or VBA.
- Help in other environments If you are using another development environment, locate and double-click the Help file owcvba10.chm.
Getting and providing
help in the browser
In the browser, Help explains how to use the features and capabilities of spreadsheets. Depending on the skills of your users and the type of work they want to do, you might want to supplement this run-time Help by providing custom instructions on the Web page for your spreadsheet, or providing a hyperlink to another Web page that has instructions on it.
Help available from the browser For users who have Microsoft Internet Explorer version 4.01 or later and the Microsoft Office Web Components, general Help specific to spreadsheets is automatically available. This run-time Help is separate from the Help available from the browser's Help menu.
The run-time spreadsheet Help topics provide general information for all users about using spreadsheets in the browser — they are not the same as the spreadsheet design Help topics you are reading now. Other Office Web Components, such as the PivotTable Component, also have their own separate Help available in the browser.
To see what Help is provided in the browser, create a spreadsheet on a Web page, open the Web page in Internet Explorer, click the spreadsheet, and then click Help on the
spreadsheet toolbar. In the Help window, you can view a table of contents and search the topic text. The Office Assistant is not available in the browser to answer questions.