Home |
Search |
Today's Posts |
#1
|
|||
|
|||
saving change in toolbar
After adding a button to the tool bar, and re-starting Excel the change has
been undone. thus having to re-add the button. In the older version this was not a problem. |
#2
|
|||
|
|||
James
Manual customizations to Toolbars and Menus are saved in a file named *.XLB XL2000 and 2002 *.xlb file will be in Documents and Settings\yourname\application data\microsoft\Excel and be Excel9.xlb or Excel10.xlb Excel 97 in C:\Windows and named username.XLB Excel 2003 same as 2000 and 2002 and named Excel11.XLB Perhaps this file is going astray? If on a server, this can happen. Also if on a server, you may not have permissions to save. See your IT guy or Administrator. Search for *.xlb and see what you come up with. When you get your customization done, make a backup copy of the *.xlb file. When you search for *.xlb you may come up with more than one. Make some changes to your Toolbar or Menu then save and close Excel. Check to see which *.xlb updated. That would be the one to backup. One more thing about the *.XLB file. If it gets too large(30kb) I hear it can start causing problems. Gord Dibben Excel MVP On Thu, 10 Feb 2005 08:13:04 -0800, "James" wrote: After adding a button to the tool bar, and re-starting Excel the change has been undone. thus having to re-add the button. In the older version this was not a problem. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link two cells as to allow me to change the value in eit. | Excel Discussion (Misc queries) | |||
Use DocProps in a change declaration | Excel Worksheet Functions | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
saving toolbar | Excel Discussion (Misc queries) |