Mark Simms
marksimms at verizon.net
Sat Nov 27 11:31:16 CST 2010
Well, it's been a lot of time invested to understand how the ribbon operates and how to control it. In Summary: 1) There is no way to convert older Commandbars built in VBA, however, those created thru the GUI can be converted. I don't think the conversion can be done programmatically....i.e. command-line or vba proc. 2) Older commandbars will show-up ONLY in the Add-ins tab of the default Ribbon. If you attempt a custom ribbon, NONE of the commandbar items are available...i.e. your users can do nothing. The commandbars cannot be placed anywhere else. 3) Although Form and Print ribbons have been reverse engineered and can be defined to contextually appear, no one has reverse engineered the entire default ribbon. i.e. there is no XML for the default ribbon. If there were, then older commandbars could be placed in a user-controlled tab. 4) There is a tool to assist in enabling/disabling buttons on a ribbon via VBA, however, no one has created a tool that will allow a ribbon menu to be built-up in VBA similar to building commandbar pop-ups, etc. 5) The ribbon operates nicely when minimized and takes up the least amount of screen real estate. 6) There are a few third party tools to assist in building ribbon menus from scratch. However, none of them generate VBA....you become totally dependent upon them or must apply your knowledge of XML and the specifics for the Microsoft schema that was implemented (i.e. "good luck"). 7) There is a substantial body of knowledge at this forum: <http://social.msdn.microsoft.com/Forums/en-US/accessdev/threads> http://social.msdn.microsoft.com/Forums/en-US/accessdev/threads I was impressed !