Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Customized marcos cannot save to tools-bar
Dear expert,
Wanna customize a macro in Tools-bar. Have right-click the tools-bar, then add the smily face button, have assigned the macro, finally rename and select TEXT Only. The question is that I exit the Excel and the button (new button in tools-bar should have been saved automatically), but .... when I turned Excel off, the button gone nowhere. Can you tell what is wrong with my Excel setting please ? Thanks so much |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Customized marcos cannot save to tools-bar
Elton,
Those changes are stored in a file named, depending on the version that you have, Excel8.xlb - Excel11.xlb Search for that file - it is usually stored in a folder named: C:\Documents and Settings\USERNAME\Application Data\Microsoft\Excel\ If you are on a network, and do not have write permission for that file, changes to your toolbar may not be saved. Talk to your network admin in that case. If that file is corrupted, changes may not be saved. Try renaming the existing file to whatever.BAK, and start up Excel. When Excel doesn't find the file, it will create a new one, which you can use when making your changes - see if they stick, and if they do, then you had a corrupt .xlb file. HTH, Bernie MS Excel MVP "Elton Law" wrote in message ... Dear expert, Wanna customize a macro in Tools-bar. Have right-click the tools-bar, then add the smily face button, have assigned the macro, finally rename and select TEXT Only. The question is that I exit the Excel and the button (new button in tools-bar should have been saved automatically), but .... when I turned Excel off, the button gone nowhere. Can you tell what is wrong with my Excel setting please ? Thanks so much |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 won't save customized changes | Excel Discussion (Misc queries) | |||
Excel 2003: I can't save customized toolbars. | Excel Discussion (Misc queries) | |||
Marcos | Excel Worksheet Functions | |||
How can I save an other route in my Tools bar-options-save? IT | Excel Discussion (Misc queries) | |||
How can I save a customized Standard toolbar? | Excel Discussion (Misc queries) |