Okay, this has been driving me nuts for a couple months now. I finally gave up the struggle and worked on other things, but now I'm back to this workbook, and I need to get it figured out! Here's the deal. This is a fairly large workbook, even without data, which depends on an even more elaborate custom toolbar (commandbar). My problem is that I can't get any of my modifications to "stick." I'll add several new items, or move items from one menu to another, or change an image--whatever--and go through all the steps of deleting the toolbar from the workbook, attaching the changed one from the workspace, and then deleting the one from the workspace when closing the workbook. But the changes are gone when I open the workbook again. Most of the time. Every once in awhile, I'll think I'll have discovered the secret. But then, the next time I open the workbook, the new items will be missing again.
Sometimes, after three or four attempts at making changes, the toolbar that DIDN'T appear several tries ago will suddenly show up, with the original changes I made and none of the recent ones. Or it will show up with stuff missing that I didn't delete. Since I quit work on it, it has been stable, but once I start to make changes, it gets flaky again.
I thought, of course, that I must be missing something. I work primarily in Word, where toolbars are always part of the template and generally behave themselves. So I printed out three different sets of "how to" instructions dealing with the appropriate way to deal with toolbars in Excel. I followed each set, to the letter, over and over again. Same problem.
I tried renaming the workspace files. And half a dozen other desperate "won't hurt to try" techniques. For about eight hours one Saturday, back when we thought this project was only going to take two weeks, and I was frantic to get it done by Monday. Nothing. I tried copying the toolbar to a new workbook, in case my workbook was corrupted in some way. No deal.
So, on that Monday way back in June, I pulled in the other programmer, gave him the instructions, and stepped him through the process, while he double-checked me on the instructions. He couldn't figure it out. So I pulled in one of the IT guys. I had him try to make a change and get it to stick. And HE couldn't get it to work. And these are both really bright guys. REALLY bright, with the IT guy especially good at troubleshooting problems just like this. No luck.
I tried moving from Excel 2000 to XP. Nope. To Excel 2003. Nope.
I tried various combinations of deleting and/or not deleting the toolbar from the workspace when closing the document. Nope. Sometimes, not only would the changes not be there, but stuff that HAD been there would suddenly be missing. I recreated the same items so many times, I finally printed out images of them the way they were at the latest "good" point so that I could duplicate them more easily. It was driving me CRAZY!!!
I searched high and low, and had the IT guys search, too, for someone else who had the same problem. Nothing. As I've said, I've gone on to work on the other parts of the programming without modifying the toolbar, but I'm nearly to the point where I'm either going to have to figure this out or come up with another whole scheme for how the workbook will function.
So, WHAT CAN I TRY NEXT???? If you need to see the file, I can send it to an individual, but I don't want to post it. And even zipped, it is 136k.