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 |
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 |
All times are GMT +1. The time now is 11:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com