Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Saving Customized Office Toolbars
- Thread starter mviltan
- Start date
You could try this. Not sure if the file stores customised toolbars because I've never done this. But it looks like it might. (this is from excel help)
Save more than one toolbar configuration
If you frequently use a group of customized toolbars sized and arranged on the screen in a particular way, you can save the configuration so that you don't have to redisplay and size the toolbars each time.
1 Make any changes you want to the built-in menu bar and toolbars, and create any custom toolbars you want to save in the configuration. Then display the toolbars the way you want them to appear.
2 Quit Microsoft Excel.
3 In your Windows folder, locate the file named Username8.xlb, where username is your Windows or network logon name.
If your computer is not connected to a network or not set up with a logon prompt, the settings file is named Excel8.xlb.
4 Rename the file, retaining the .xlb extension.
To use a saved configuration again, use the Open command on the File menu to open the renamed toolbars settings file. Microsoft Excel creates a new default toolbars settings file Username8.xlb when you next quit the program.
Note If you cannot find the default toolbars settings file, another location for the file might be specified in your system settings. Please consult your system administrator.
Save more than one toolbar configuration
If you frequently use a group of customized toolbars sized and arranged on the screen in a particular way, you can save the configuration so that you don't have to redisplay and size the toolbars each time.
1 Make any changes you want to the built-in menu bar and toolbars, and create any custom toolbars you want to save in the configuration. Then display the toolbars the way you want them to appear.
2 Quit Microsoft Excel.
3 In your Windows folder, locate the file named Username8.xlb, where username is your Windows or network logon name.
If your computer is not connected to a network or not set up with a logon prompt, the settings file is named Excel8.xlb.
4 Rename the file, retaining the .xlb extension.
To use a saved configuration again, use the Open command on the File menu to open the renamed toolbars settings file. Microsoft Excel creates a new default toolbars settings file Username8.xlb when you next quit the program.
Note If you cannot find the default toolbars settings file, another location for the file might be specified in your system settings. Please consult your system administrator.
- Thread starter
- #3
- Thread starter
- #6
- Status
