Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
toolbar/ribbon hide/show macro
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??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
toolbar/ribbon hide/show macro
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??? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
toolbar/ribbon hide/show macro
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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get defaullt toolbar or ribbon in MS Office 2007? | Excel Discussion (Misc queries) | |||
macro to hide then show cells | Excel Discussion (Misc queries) | |||
Show or Hide a worksheet with a macro | Excel Discussion (Misc queries) | |||
Macro for Show/Hide Column | Excel Discussion (Misc queries) | |||
Show Record Macro Toolbar | Excel Programming |