Jim,
thanks for info. I'm not a programmer in any way shape or form but I;ll
take a look and see if I can understand it all.
"Jim Rech" wrote:
There is no programmatic model for modifying the ribbon as there was for
command bars. Rather, ribbon modifications are made by embedding a special
type of XML, known as RibbonX, in the Excel 2007 workbook.
Here are some resources:
http://msdn2.microsoft.com/en-us/office/aa905530.aspx
http://www.rondebruin.nl:80/tips.htm
http://pschmid.net/index.php
--
Jim
"barrowhill" wrote in message
...
| Just aquired Office 2007 and trying to get used to new user interface....
|
| Have existing worksheets with various button activated macros fronted by a
| menu. I'd like to be able to make visible/unvisible the "toolbars", or is
it
| "ribbon" that I could in earlier versions e.g.
|
| Application.CommandBars("Formatting").Visible = False
|
| Can anyone help be with with macro to turn on/off toolbars or whatever
they
| are now called???