New for Office 2011, the Ribbon is like a large, thick toolbar that takes up a fixed area of screen real estate. This first iteration of the Ribbon in Office 2011 offers limited customization capabilities. You can customize the Ribbon by clicking the wheel at the right edge of the Ribbon. The Ribbon doesn’t respond to XML, VBA, or other programmatic customizations.

When you choose Ribbon Preferences from the menu, a Ribbon dialog opens. Another way to access the same dialog is through [Application Name]→Preferences; then click the Ribbon button.

In Office 2011 for Mac, Excel has a special kind of sheet called a dialog sheet, on which you can make an input form such as the one you see when you’re in an Excel 2011 for Mac table and choose Data→Form. You can probably make one much nicer if you put your mind to it.

The Ribbon dialog has the following options:

• Turn on the Ribbon: When selecting, the Ribbon is on and this is the default setting. To turn the Ribbon off, deselect this setting.

• Expand Ribbon When Document Opens: When selected, the entire Ribbon is visible when opening a file. When deselected, only the Ribbon tabs are displayed when a document opens. If you choose this option and then want to see the entire expanded Ribbon, just click any of the Ribbon tabs visible.

• Hide Group Titles: This turns off the display of group names in the Ribbon tabs, which may give you a little more screen estate.

  Monotype corsiva font free for mac. LicensePlease read this before any use of the font.-This font is for PERSONAL USE ONLY:Do not under any circumstances use the font in public media unless permission is given from designer Mns Grebck or legal reseller. Contact Information:Ascender CorporationWeb http://www.ascendercorp.com/. Except as specifically permitted by the license, you may not copy this font software.If you have any questions, please review the license agreement you received with this font software, and/or contact Ascender Corporation.

• Appearance: Choose between either the application theme or graphite. The application theme is different for each Office 2011 application. In Word 2011, it’s called Word Blue.

• Show or Hide Tabs, or Drag Them into the Order You Prefer: Select or deselect tabs and groups. Drag items in this box to re-order the Ribbon.

• Description: As you move your mouse over command buttons and controls, a description dynamically appears in the panel.

In addition to using the Ribbon preferences, you can choose the Customize Ribbon Tab Order option from the pop-up menu. This option temporarily changes the appearance of the tabs and allows you to drag Ribbon tabs to change their order. Click the Done button when you’re done rearranging the tabs. If you made changes that you don’t like, click the Reset button to set the tab order to default.

In Office 2011 for Mac, Excel has a special kind of sheet called a dialog sheet, on which you can make an input form such as the one you see when you’re in an Excel 2011 for Mac table and choose Data→Form. You can probably make one much nicer if you put your mind to it. Another use for dialog sheets is to make your own wizards.

Dialog sheets gain new prominence by having their form controls exposed on the Ribbon in Excel 2011. Beginning with Excel 98, VBA Userforms largely replaced dialog sheets. The Text Box, Combo List Edit, and Combo Dropdown Edit form controls found on the Developer tab of the Ribbon can be placed only on a dialog sheet.

Making a dialog sheet in Excel 2011 for Mac

Making a dialog sheet is easy! Choose Insert→Sheet→Dialog Sheetto display a new, default dialog sheet cleverly called Dialog 1. Notice that all of the Form Controls on the Developer tab of the Ribbon.

The rest of this chapter requires VBA (visual basic applications). It covers essential things you must do in Excel 2011 to make full use of dialog sheets.

Running a dialog sheet in Excel 2011 for Mac

After you place controls onto a dialog sheet, you run the sheet to use the controls. There’s a catch! The Run button isn’t on the Ribbon or even in the Customize Toolbars and Menus dialog. You can find the Run button on the free Excel 2011 MVP Toolbar.

• Run Dialog: To make a dialog sheet work, you have to run it. Clicking this button runs the dialog while you’re building your form. Usually you exit a dialog using a control, but you can also press the Esc key. After you’ve finished making your dialog, you would have a macro run it. Developers tend to hide dialog sheets (Format→Sheet→Hide) and display them only when they are needed.

• Design Mode: Click this toggle button to enter or exit Design mode.

• Edit Code: Select a control, and then click this button to view or edit the VBA code associated with the selected control in the VB Editor (VBE).

• Control Properties: Select a control and then click this button to display the Format Control properties dialog for the selected control.

Now you have everything you need to make and edit dialog sheets. Examples of how to program dialog sheets are on the Internet and in books dealing with programming for Excel version 5.