Saving toolbar changes

[Guest]

After spending a lot of time to customize a toolbar in Excel 2003, it disappears when opening up another file, or starting the app again. I repeatedly change it, save it as XLB, XLT, save multiple copies in every possible location...but the damn thing always defaults to its own toolbar settings. This makes toolbars almost useless.

How can one insist that PPT use YOUR toolbar setting, rather than its own default

Thanks.

 

[David McRitchie]

Hi Jeff,
If I have a lot of tool bar changes to make, I close all the
workbook that are not hidden then unhide my personal.xls
from the Window menu.

I don't know why sometimes the changes take place and
sometimes they don't but I never had any problem with
only the personal.xls file open. When finished hide your
personal.xls file again.

If you would like to document the toolbar menus that you have
see http://www.mvps.org/dmcritchie/excel/barhopper.htm
with descriptions, and a more complete version of a macro at
http://www.mvps.org/dmcritchie/excel/code/BarHopper_ws.txt

After spending a lot of time to customize a toolbar in Excel 2003, it disappears when opening up another file, or starting the app

again. I repeatedly change it, save it as XLB, XLT, save multiple copies in every possible location...but the damn thing always
defaults to its own toolbar settings. This makes toolbars almost useless.

 

[Dave Peterson]

How do you save it as XLB or XLT?

I just close excel and it saves my toolbar as *.xlb.

I also use windows|find (or Search) to find that *.xlb and make a backup--just
in case something bad happens to mine.

If my customized toolbar (with hours of work) disappears, I just close excel and
copy the backup into the "real" location.

And I don't use PPT enough to offer any suggestion. (Did you mean powerpoint??)

 

[Guest]

Thanks, Dave. I would suggest to other baffled users that once one has determined which *.xlb is being changed, make the changes desired in the toolbar, copy it under another name as backup, and save it under Excel and Excel/startup just to be sure. And finally, delete all other files with .xlb extensions

Amazing that Excel 2003 is so user-unfriendly with respect to this. How many thousands of hours have been shot by users trying to figure out how to outfox the unfriendly MS code...

Jeff

 

[Dave Peterson]

I don't think many people have the problem that you have. I'm still using
xl2002, but haven't had anything like this happen to me.

But I would store my backup as the same name, but in a different folder--and
only restore it when the problem occurred.