So we upgraded to 2007 at work. I've been struggling with it at home for close to a year. I've relearned some of the shortcuts which are pointlessly (if that's a word; if not, it should be, because how else do you describe the "upgrades" in Office '07?) different, but have not been able to get around to updating my tools add-in because it just didn't have the payoff for home-use only. Well, no more, I can no longer sit back and hit Alt-X-Y (and why, Microsoft, why? What is the reason for assigning a default "Y" and not letting me pick?? Was the "Y" the lucky target in a dart-throw?). My tools are called Zach's Tools, dang it, and the shortcut should be a simple Z. So, rant aside, I have managed to play around with the Data Pig template and the keyTip property to get my tools to use the Z. Now instead of Alt-X-Y, it's Alt-Z-Z to get to my ugly old-school style menus.
My problem is this: I want to setup a custom ribbon to take over the old menus I have. That breaks down into two subproblems. One is that there's about 40 different tools and I don't relish the thought of building the ribbon by hand. I suppose I could use the Data Pig template, but is there a better way? The other issue is that there just isn't room on the ribbon to fit them all and, even if I could, I don't know if 40 items on a ribbon is the best way to go. Any thoughts? The tools are broken down into 5 categories so I was thinking maybe a drop-down list for each of the categories, but I don't know how to do that. An example of that would be the drop-down under the "From Other Sources" item on the "Data" ribbon.
Also, one other problem is that the first category of my toolbar is a custom bookmark menu with my 20 favorite files. I can change those files from a userform which saves the names and paths on the add-in worksheet. Those are read by the add-in on load so the names of the toolbar items are not static. I'm guessing this is a no-go with the ribbon layout. I suppose I can just pin my favorites to the Home menu to get a similar effect, but I hate to lose the functionality if I don't have to.
How has everyone else been dealing with the transition of their toolbars?