Office 2007 Ribbon

I’ve not previously done much with CommandBars in 2000/2003, since my applications were tied to particular workbook structures, and thus used forms or on-worksheet controls. However, I think it’s time to have a look at the Ribbon extensibility in Office 2007.

Although the Ribbon has been criticized for taking up a lot of screen area, its size means that there is more scope for displaying useful information, rather than just holding toolbar buttons. So it might be possible to use a custom ribbon tab as a permanently visible form, with combo boxes and other controls. Obviously, any facilities still have to be applicable to a wide range of differently structured workbooks. I’m thinking of various ‘smart’ navigation facilities, as an example.

A significant difference with the 2007 ribbon is that the customizations are expressed in XML, and added to the workbook ‘file’. As is well known, an Office 2007 file is actually a zipped archive containing various folders and files. You can open it with WinZip (or 7-Zip, if you prefer a free tool).

It’s apparent from the Microsoft technical articles that the approach is not specific to VBA, but is also intended for heavier-weight usage by C#/.Net developers – hence the use of XML configuration. However, this means that while it’s quite easy to stick a few command buttons on a ribbon tab, things can get quite a lot more complicated… I’m still investigating, and will post again in a day or so.


3 Responses to “Office 2007 Ribbon”

  1. 1 August 13, 2013 at 11:14 am

    Now I am going away to do my breakfast, when having
    my breakfast coming yet again to read more news.

  2. 2 crown king arizona map March 24, 2014 at 10:15 am

    On defense, SS #6 and ROLB #11 are standout players.
    Queen Hatshepsut was careful to behave as a conventional King of Egypt right from her coronation.
    In the summer visitors encounter refreshing monsoons and warm afternoons.

  1. 1 Office 2007 Ribbon – Part 2 « Roy MacLean’s VBA Blog Trackback on December 15, 2009 at 4:31 pm

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

December 2009
« Nov   Jan »

%d bloggers like this: