toolbar/ribbon hide/show macro

[Guest]

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???

 

[Jim Rech]

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
| 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???

 

[Guest]

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.