Microsoft KB Archive/161235

= XL97: How to Use a Toolbar Settings File from a Network Share =

Article ID: 161235

Article Last Modified on 8/27/2002

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q161235



IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry



SUMMARY
This article contains information about using a Microsoft Excel toolbar settings file that is stored on a shared location on a network.



MORE INFORMATION
Toolbars allow you to organize the commands in Microsoft Excel so that you can find and use them quickly. For example, you can add and remove menus and buttons, create your own custom toolbars, hide or display toolbars, and move toolbars. In Microsoft Excel 5.0 and 7.0, toolbars contain only buttons. Now toolbars can contain buttons, menus, or a combination of both.

When you quit Microsoft Excel, changes you make to the menu bar and built-in toolbars, custom toolbars you create, and toolbars you display are saved in a toolbars settings file in the Windows folder. Microsoft Excel saves this settings file as 8.xlb, where   is your Windows or network logon name. If your computer is not connected to a network, or is not set up with a logon prompt, Microsoft Excel saves the settings file as Excel8.xlb.

Microsoft Excel 97 also allows you to use a toolbar settings file from a shared location on the network. This allows you to log on to any computer that has access to the network and gain access to a personal toolbar and menu settings file on the network server.

To use this feature, you must add a key to the registration database on each of the computers that is connected to the network.

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

To use a Microsoft Excel toolbar settings file from a network share:  Copy the user's toolbar settings file to a shared folder on the network. This file is located in the Windows folder on any computer on which the user logged-on and ran Microsoft Excel.

Note that running Microsoft Excel creates a local toolbar settings file called 8.xlb, where   is the Windows or network logon name of the current user. On the Start menu, click Run. In the Open box, type regedit and click OK. Open the following subkey (folder) in the registry:

HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel\Microsoft Excel

 On the Edit menu, point to New, and click String Value. Type CmdBarFile as the name of the new string value. Leave the CmdBarFile string value selected, and click Modify on the Edit menu.

This step opens the Edit String dialog box. In the Data Value box, type a valid path to the shared folder on the network that contains the user's toolbar file.

The following example shows the syntax to use for the string:

\\ \ \

where  is the name of the server on which the shared folder that contains the toolbar setting file is located, and   is the name of the shared folder.

IMPORTANT: The path must end with a trailing backslash, and the user must have read/write permission to the shared folder and the toolbar file.</li></ol>

<div class="references_section">