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 you’ve 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.

IV-1 Hive: HKEY_LOCAL_MACHINE
  Key: Software\Microsoft\Office\8.0\Common\Assistant
  Value Name: AsstPath
  Data Type: REG_SZ
  Value: C:\Program Files\Microsoft Office\Office\Actors

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.

IV-2 Hive: HKEY_LOCAL_MACHINE
  Key: Software\Microsoft\Office\8.0\Common\Assistant
  Value Name: AsstSourcePath
  Data Type: REG_SZ
  Value: E:\Office\Actors

This value stores the source path for the support files Office 97 needs for the actor files.

IV-3 Hive: HKEY_LOCAL_MACHINE
  Key: Software\Microsoft\Office\8.0\Common\Assistant
  Value Name: AsstFile
  Data Type: REG_SZ
  Value: Clippit.act

This key is handy if you don’t 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

Clippit.act Clippit Paper Clip
Dot.act The Dot (Bouncing Ball)
Genius.act The Genius (Einstein)
Hoverbot.act Hover Bot
Logo.act Office Logo
Mnature.act Mother Nature
Powerpup.act Power Pup (The Power Dog)
Scribble.act Scribble (The Paper Cat)
Will.act Will (William Shakespeare)

IV-4 These next two registry entries control the location of the Office Assistant on the screen.

Hive: HKEY_LOCAL_MACHINE
Key: Software\Microsoft\Office\8.0\Common\Assistant
Value Name: AsstTop
Data Type: REG_DWORD
Value:

IV-5 Hive: HKEY_LOCAL_MACHINE
  Key: Software\Microsoft\Office\8.0\Common\Assistant
  Value Name: AsstLeft
  Data Type: REG_DWORD
  Value:

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 you’re working on something?

Hive: HKEY_LOCAL_MACHINE
Key: Software\Microsoft\Office\8.0\Common\Assistant
Value Name: AsstMoveWhenInTheWay
Data Type: REG_DWORD
Value: 1

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.

Hive: HKEY_LOCAL_MACHINE
Key: Software\Microsoft\Office\8.0\Common\Assistant
Value Name: AsstSounds
Data Type: REG_DWORD
Value: 1

Setting this value to 0 disables sound for the Assistant.

IV-8 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Common\Assistant
  Value Name: AsstState
  Data Type: REG_DWORD
  Value: 0x5 (5)

This value lets you control the size of the Assistant window. Valid values are

0x5 Large and Visible
0x9 Small and Visible
0x6 Large but Hidden
0xa Small but Hidden

IV-9 Microsoft includes tip wizards with all the Office 97 products. These next seven registry entries let you enable or disable the wizards.

Hive: HKEY_LOCAL_MACHINE
Key: Software\Microsoft\Office\8.0\Common\Assistant
Value Name: AsstShowTipOfDay
Data Type: REG_DWORD
Value: 1

Tired of seeing all the tips of the day? Setting this value to 0 disables these tips.

IV-10 Hive: HKEY_LOCAL_MACHINE
  Key: Software\Microsoft\Office\8.0\Common\Assistant
  Value Name: AsstFeatureTips
  Data Type: REG_DWORD
  Value: 1

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.

IV-11 Hive: HKEY_LOCAL_MACHINE
  Key: Software\Microsoft\Office\8.0\Common\Assistant
  Value Name: AsstKeyboardShortcutTips
  Data Type: REG_DWORD
  Value: 1

Setting this value to 1 makes the Office Assistant show you keyboard shortcuts for functions that take complicated mouse and menu commands to accomplish.

IV-12 Hive: HKEY_LOCAL_MACHINE
  Key: Software\Microsoft\Office\8.0\Common\Assistant
  Value Name: AsstMouseTips
  Data Type: REG_DWORD
  Value: 1

Setting this value to 1 makes the Office Assistant watch your mouse commands and show you tips for using your mouse more effectively.

IV-13 Hive: HKEY_LOCAL_MACHINE
  Key: Software\Microsoft\Office\8.0\Common\Assistant
  Value Name: AsstAssistWithHelp
  Data Type: REG_DWORD
  Value: 1

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.

IV-14 Hive: HKEY_LOCAL_MACHINE
  Key: Software\Microsoft\Office\8.0\Common\Assistant
  Value Name: AsstAssistWithAlerts
  Data Type: REG_DWORD
  Value: 1

Setting this value to 1 enables the Office Assistant to show you help messages.

IV-15 Hive: HKEY_LOCAL_MACHINE
  Key: Software\Microsoft\Office\8.0\Common\Assistant
  Value Name: AsstGuessHelp
  Data Type: REG_DWORD
  Value: 1

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.

IV-16 Hive: HKEY_LOCAL_MACHINE
  Key: Software\Microsoft\Office\8.0\Common\Assistant
  Value Name: AsstOnlyHighPriorityTips
  Data Type: REG_DWORD
  Value: 1

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.

IV-17 Hive: HKEY_LOCAL_MACHINE
  Key: Software\Microsoft\Office\8.0\Common\Assistant
  Value Name: AsstOfficeWizards
  Data Type: REG_DWORD
  Value: 1

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.

IV-18 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: DefaultPath
  Data Type: REG_SZ
  Value: D:\My Documents

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.

IV-19 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Shared Tools\Outlook\Journaling\ Microsoft Excel
  Value Name: Enabled
  Data Type: REG_DWORD
  Value: 0x1

This value controls the Journaling feature in Microsoft Outlook and tracks when and how long you work with any Microsoft Excel Documents.

IV-20 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: Maximized
  Data Type: REG_DWORD
  Value: 0x3

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:

3 Excel and Workbook window maximized
2 Workbook window maximized
1 Excel maximized, Workbook window not maximized
0 Nothing maximized

IV-21 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: Pos
  Data Type: REG_SZ
  Value: left, top, right, bottom

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

IV-22 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: Default Chart
  Data Type: REG_SZ
  Value: <type:charttype, subtype>

This value sets Excel’s 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.

IV-23 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: DefSheets
  Data Type: REG_DWORD
  Value: 0x3

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.

IV-24 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: MoveEnterDir
  Data Type: REG_DWORD
  Value: 0x1

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
0 Down
1 Right
2 Up
3 Left

IV-25 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: DefFileMRU
  Data Type: REG_DWORD
  Value: 0x4

This value controls the number of most recently used files to display under the File Menu.

IV-26 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: Font
  Data Type: REG_SZ
  Value: Arial,10

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.

IV-27 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: MenuKey
  Data Type: REG_DWORD
  Value: 47

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.

IV-28 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: Randomize
  Data Type: REG_DWORD
  Value: 1

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 Excel’s dialog boxes appear on the screen. Excel updates these values when it closes.

Hive: HKEY_CURRENT_USER
Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
Value Name: StickyPtX
Data Type: REG_DWORD
Value: 479

IV-30 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: StickyPtY
  Data Type: REG_DWORD
  Value: 241

IV-31 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: SortCaseSensitive
  Data Type: REG_DWORD
  Value: 0x0

This value controls the default Case Sensitive setting for the sorting algorithm that Microsoft Excel uses.

IV-32 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: CustomSortOrder
  Data Type: REG_DWORD
  Value: 0x0

This value controls the default setting of the First key sort order, which appears under the Sort/Options dialog box.

IV-33 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: AutoFormat
  Data Type: REG_DWORD
  Value: 0x2

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.

IV-34 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: AutoFormat Options
  Data Type: REG_DWORD
  Value: 0x3f (63)

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

1 Number
2 Font
4 Alignment
8 Border
16 Patterns
32 Width/Height

Simply add the values of the options you want. The final value is their sum. For example, if you wanted just the Border and Font options, add 8 and 2 for a value of 10.

IV-35 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Recent File List
  Value Name: File1 or File2 or File3, etc.
  Data Type: REG_SZ
  Value: <last used file>

These values show the most recently used files that appear on the bottom of the File menu.

IV-36 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: Basics
  Data Type: REG_DWORD
  Value: 1

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.

IV-37 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: AddIn Path
  Data Type: REG_SZ
  Value: <paths of add-on programs>

In this value, you tell Excel the directories to search in for add-on programs and tools. Separate multiple paths with semicolons (;).

IV-38 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: AltStartup
  Data Type: REG_SZ
  Value: <path of alternate startup folder>

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.

IV-39 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: 3dDialogs
  Data Type: REG_DWORD
  Value: 0x1

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.

IV-40 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: AutoCalculate
  Data Type: REG_DWORD
  Value: <index value>

This value sets the AutoCalculation function. Your options are

0 Count Nums
4 Sum
5 Average
6 Min
7 Max
169 Count

IV-41 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: User
  Data Type: REG_SZ
  Value: <user name>

This value is the user name that Microsoft Excel attaches to Workbooks.

IV-42 Hive: HKEY_CURRENT_USER
  Key: Software\Microsoft\Office\8.0\Excel\Microsoft Excel
  Value Name: CfDDELink
  Data Type: REG_SZ
  Value: 1

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
Hosted by www.Geocities.ws

1