Customizing the Ribbon

The new Ribbon UI in Excel 2007 is a dramatic shift in user interface design. Fortunately, the developer has a fair amount of control over the Ribbon. Unfortunately, modifying the Ribbon isn't a simple task.

CROSS- See Chapter 22 for information about working with the Ribbon.


Menu and Toolbar Compatibility

Excel 2007 still supports custom menus and toolbars, but the way these UI elements are handled may not be to your liking.

The following figure shows a custom menu and toolbar displayed in Excel 2003. The menu and toolbar were created using my Power Utility Pak add-in. Each menu item and toolbar button executes a macro.

Menu and Toolbar Compatibility

EhkI 2C0? Hi!I support! custom menus and raaibars, but iht my lhest UI sie^encs. ar? handled may nol im 1.c yo-gr h ■. ng

1 ha lollowing liyu ;# ¿lrau.3 j ciKiorn rnanu jno -.oolbjr d ¡.p jyua iiii Excal ¿003. the rni^y snd totems* v«*fe U14g "flfiic r Utility P4c «W-ln ffHOU item and la-alb v button cxecirtcs a nanrc-



As shQMn in the fallowing figu-nt, when the Pawqr Utility Fafc .« d^in is installed in Fx cell ¿'■JO/, thu tustoin nivnu dippwdrv in -d yruup IdiMtivd Atki-!n»< Mvikj JI>J

th* jitmvi IC'Olbar ri in * Ah* a J Add-lra Cus:om T»Jhbrii£th« Toolbars esnrtr b* moved &r fiiiz^J). "hise ftibfcon grc^&s e iphry ihe tr-trw addiiiamand ■.aelhfiri f-tr all ths W »tatk>ni gr acd-ini ;ha| ai-i "hfl inflnu ¡fern« *nd toolbar buttons s 1111 iundion, but lht dt-stgn*"1*! -engine! Ul coftcvptiQnh-ai ba#ri corn prom iw»d ciorat'tfiued

As shown in the following figure, when the Power Utility Pak add-in is installed in Excel 2007, the custom menu appears in a group labeled Add-lns Menu Commands, and the custom toolbar is in a group labeled Add-Ins Custom Toolbars (the toolbars cannot be moved or resized). These Ribbon groups display the menu additions and toolbars for all the applications or add-ins that are loaded. The menu items and toolbar buttons still function, but the designer's original UI conception has been compromised.

confirm iwf

.4 >■ -4.



I^NH i— f-


TW j


* H

i \ J

T f 1. W04 4

ld □ r

. - ■ Jp %


m--r-i' 'm





4 j' nip

J frmfhm


4 Lwi—■


% ' ■ 9





-H* 3

Was this article helpful?

0 0

Post a comment