Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I save a custom toolbar?
I use custom toolbars wherein I assign macros from my personal.xls. After
inserting a new button, I save my "book1.xls" and exit the program. When I come back on, my new custom toolbar appears briefly and then changes back to my old custom toolbar. What is happening? Thanks. |
#2
|
|||
|
|||
Art
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 Sat, 2 Apr 2005 14:07:01 -0800, "Art Kaufman" <Art wrote: I use custom toolbars wherein I assign macros from my personal.xls. After inserting a new button, I save my "book1.xls" and exit the program. When I come back on, my new custom toolbar appears briefly and then changes back to my old custom toolbar. What is happening? Thanks. |
#3
|
|||
|
|||
I'm betting you have another *.xlb file in your xlstart folder that's fighting
with the real toolbar file. Close excel and do a search for *.xlb. windows start button|Search My "real" *.xlb file is in: C:\Documents and Settings\(username)\Application Data\Microsoft\Excel (xl2003 and winXP) This is the same folder that holds my XLStart folder. Make a note of the file that contains the most current date--the one you changed. Move all the others to a nice safe location. (You can either delete them later or move them back.) Art Kaufman wrote: I use custom toolbars wherein I assign macros from my personal.xls. After inserting a new button, I save my "book1.xls" and exit the program. When I come back on, my new custom toolbar appears briefly and then changes back to my old custom toolbar. What is happening? Thanks. -- Dave Peterson |
#4
|
|||
|
|||
Thank you very much. It was being stored under Excel11.xlb and another file
under XLStart named excel.xlb. Appreciate your help. "Art Kaufman" wrote: I use custom toolbars wherein I assign macros from my personal.xls. After inserting a new button, I save my "book1.xls" and exit the program. When I come back on, my new custom toolbar appears briefly and then changes back to my old custom toolbar. What is happening? Thanks. |
#5
|
|||
|
|||
Thank you very much. It was being stored under Excel11.xlb and another file
under XLStart named excel.xlb. Appreciate your help. "Dave Peterson" wrote: I'm betting you have another *.xlb file in your xlstart folder that's fighting with the real toolbar file. Close excel and do a search for *.xlb. windows start button|Search My "real" *.xlb file is in: C:\Documents and Settings\(username)\Application Data\Microsoft\Excel (xl2003 and winXP) This is the same folder that holds my XLStart folder. Make a note of the file that contains the most current date--the one you changed. Move all the others to a nice safe location. (You can either delete them later or move them back.) Art Kaufman wrote: I use custom toolbars wherein I assign macros from my personal.xls. After inserting a new button, I save my "book1.xls" and exit the program. When I come back on, my new custom toolbar appears briefly and then changes back to my old custom toolbar. What is happening? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep custom toolbar settings - Help!! | Excel Discussion (Misc queries) | |||
custom toolbar not saved | Excel Discussion (Misc queries) | |||
Copying a workbook with custom toolbar assigned to a macro | Excel Discussion (Misc queries) | |||
custom toolbar w/ macro | Excel Discussion (Misc queries) | |||
I would like to delete a custom toolbar from the workspace. How? | Setting up and Configuration of Excel |