I've been playing with some menu and toolbar customizations lately. I understand that these changes are captured each session in an .xlb file (in my case, C:\WINNT\cln018.xlb ... where cln01 is my username on this computer and 8 is my version of Excel--'97). So the file is automatically named how it is. (WINNT in this case = Windows 2000.)
However, for some reason the menu changes that I make that are other than 'plain vanilla' Excel commands (by which I mean buttons linked to macros in Personal.xls, for example, instead of 'Excel generic' command buttons) cause Excel to not start. I get various 'unable to read memory' errors and Excel just plain will not start.
To get around this, I've found that if I move the .xlb file created after my customization into my XLStart directory, then Excel starts, reads that file, and it works just fine. Fine, that is, until I close Excel with the changes that the .xlb file in XLStart creates and ... saves again in WINNT by default. So after each Excel session I need to either wipe out cln018.xlb from WINNT or move it to XLStart. If I don't do that, then Excel crashes on start again, and I get that rude reminder that I should have fixed things up after the last session. So if I'm starting and stopping Excel a number of times during the day, I've got a big nuisance having to do all this housekeeping all the time.
Both of these options are a pain. What can I do to let Excel create and store its .xlb file normally and let me use the program without this workaround? I would prefer not to have to use a macro to re-create the toolbar and menu changes each time, but if that's what it takes then I guess I'll get started. I definitely want to keep the modifications!