|
Microsoft Office Registry
Secrets Table of contents |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Abstract This chapter contains registry entries that let you completely customize your Office environment, from the cursors and sounds you use to interact with Word, Excel, PowerPoint, and Access to the actors that guide you through the intricacies and nuances of Office 97. Dean Porter, the chief architect of this chapter, gives you the building blocks to construct the perfect Office 97 environment. MICROSOFT ASSISTANT FOR OFFICE 97 By now youve seen the paper clip that helps you through the trials and tribulations of using Office 97. You can add extra features to this little critter and bend his will to your own with these registry entries.
This value contains the path where the actor files are stored. It is almost certain that Microsoft and third-party vendors will make new actors available. This path lets you add new actor files as they become available. These files are the Office Assistant actor (. act) and preview (.acp) files that are located on your system.
This value stores the source path for the support files Office 97 needs for the actor files.
This key is handy if you dont want to dig out your Office 97 CD every time you change the assistant. This value is the name of the file that Office 97 uses for the assistant. Note that this value is just the filename, not the full path to the file. Valid values include
For each of these keys, the value is the location where the Assistant appears on the screen, given in pixels. Set these values to determine the location of the top left corner of the Assistant. IV-6 Would you like to stop the Assistant from moving around on you while youre working on something?
Set this value to 0 to keep the Assistant from moving. IV-7 The noises the Office Assistant makes are fun, but after hearing them about a thousand times, you want it to just shut up. This registry entry lets you do just that.
Setting this value to 0 disables sound for the Assistant.
This value lets you control the size of the Assistant window. Valid values are
Tired of seeing all the tips of the day? Setting this value to 0 disables these tips.
Setting this value to 1 shows tips for features you may not know about and suggests better ways to use the features you do know about.
Setting this value to 1 makes the Office Assistant show you keyboard shortcuts for functions that take complicated mouse and menu commands to accomplish.
Setting this value to 1 makes the Office Assistant watch your mouse commands and show you tips for using your mouse more effectively.
Setting this value to 1 shows the Office Assistant when you press the F1 key in any Microsoft Office application. Setting this value to 0 makes the Help function appear instead of the Office Assistant. Note: In some areas, Help appears when you press the F1 key regardless of this setting.
Setting this value to 1 enables the Office Assistant to show you help messages.
Setting this value to 1 enables context-sensitive help. Set this value to 0 if you do not want help topics to appear unless you specifically ask for help.
Setting this value to 1 shows you only the tips that are important, such as those that alert you to timesaving features. This feature is great for moving from a beginner to an advanced user.
Setting this value to 1 enables the Office Assistant to provide help with most of the wizards in Microsoft Office applications. MICROSOFT EXCEL 8.0/97 The following registry keys control the various options that are available within Microsoft Excel 97. Note that to change any of these options, you must exit Excel, change the registry key, then restart Excel.
This value sets the default storage location and search path for documents that you create or use in Microsoft Excel 97. This value overrides the path set in the HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Ex plorer\User Shell Folders\Personal registry key.
This value controls the Journaling feature in Microsoft Outlook and tracks when and how long you work with any Microsoft Excel Documents.
This value controls how Excel displays its window and workbook window when starting up. Note that Excel overwrites this value with its current settings when it exits. You have the following options for this value:
This value tells Excel how big to make its window and the position of the Top, Left, Right and Bottom corners of its window. An example of a valid value is 66,66,600,411
This value sets Excels default chart, which is a two-dimensional column chart. The type can be Standard, Built-in, or User-defined; for the charttype variable, select one of the charts listed in the Chart Type menu on the Chart/Chart Type dialog box. Similarly, for the subtype variable, choose one of the Chart sub-types found in the same dialog box. The default value is Standard:1,1. Note that user-defined chart formats are stored in a file called Xlusrgal.xls, which is located in the Program Files\Microsoft Office\Office folder.
This value tells Excel how many worksheets to create in a new workbook. If you set this to 1, a new workbook contains only one worksheet.
If the Move selection after Enter function is enabled, this value controls the direction the selection cursor moves after you press Enter in the current cell. Valid values are
This value controls the number of most recently used files to display under the File Menu.
This value specifics the default font and size to use for new worksheets. It also controls the default font used for the Normal style and for the row and column headings.
This value specifies the key to use to activate Excel menus or Help functions; normally this value is a forward slash (/), which is the menu key used for Lotus 1-2-3. This is the value of the key in ASCII.
This value causes Microsoft Excel to generate a unique random number each time you use the RAND function. IV-29 The next two registry keys control where Excels dialog boxes appear on the screen. Excel updates these values when it closes.
This value controls the default Case Sensitive setting for the sorting algorithm that Microsoft Excel uses.
This value controls the default setting of the First key sort order, which appears under the Sort/Options dialog box.
This value is the default AutoFormat choice that appears under the AutoFormat dialog box. The value specifies an index number that points to a Table Format.
This value controls the format options specified in the AutoFormat registry key; the options correspond to the attributes in the AutoFormat dialog box. The available options are
These values show the most recently used files that appear on the bottom of the File menu.
If this value is set to 0, Microsoft Excel starts up with the Office Assistant, which displays a menu that lets you see key information. After you click Start using Microsoft Excel, Excel sets this value to 1, thereby disabling this function. If you want to go back and learn about the new features, set this value to 0.
In this value, you tell Excel the directories to search in for add-on programs and tools. Separate multiple paths with semicolons (;).
This value specifies the location of the alternate startup folder. Microsoft Excel automatically loads files from this directory after loading files from the Xlstart folder.
This value tells Microsoft Excel to use 3-D dialog boxes. If you prefer the look of regular dialog boxes, set this value to 0.
This value sets the AutoCalculation function. Your options are
This value is the user name that Microsoft Excel attaches to Workbooks.
If this value is set to 1, Microsoft Excel remembers the last clipboard format used for a successful DDE operation. Setting this option helps reduce the time required for future DDE operations. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Page: 1, 2, 3, 4, 5, 6 |
next page | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||