Microsoft Office Tutorials and References
In Depth Information
Using the Mini Toolbar
Using the Mini Toolbar
Excel 2007 introduced a new user interface element known as the Mini Toolbar. This little pop-up
toolbar appears whenever you right-click an object (a range of cells, a chart legend, or a shape,
for example). The Mini Toolbar appears above the shortcut menu and contains icons that are
normally found on the Home tab. Figure 46-1 shows the Mini Toolbar that appears when I right-click
a chart title. Using the Mini Toolbar is especially useful if you need to apply some formatting and
the Home tab isn’t selected.
Figure 46-1: A Mini Toolbar appears above the shortcut menu whenever you right-click an object.
The icons displayed on the Mini Toolbar vary a bit, depending on the element that’s selected. In
Word, the Mini Toolbar is available when you make a selection (right-click not required) and is
semitransparent, becoming less transparent when you move your mouse toward it. This type of
behavior doesn’t occur in Excel.
The main problem with the Mini Toolbar is remembering to use it. When I first started using Excel
2007, I tended to just ignore the Mini Toolbar. But after I got in the habit of using it, I realized
that it really is a convenient feature. If you disagree and want to prevent the Mini Toolbar from
appearing, you need to use VBA. Execute this statement to turn off the Mini Toolbar:
Application.ShowMenuFloaties = True
That’s not a typo. To turn off the Mini Toolbar, you set the property to True, not False. And, a bit
of trivia: When Office 2007 was being developed, the original term for Mini Toolbars was floaties .
That term still survives in the Excel object model.
You may have noticed an option in the General tab of the Excel Options dialog box: Show Mini
Toolbar on Selection. That option determines whether the Mini Toolbar appears when you select
text while editing a cell.
And finally, you cannot customize the Mini Toolbar. What you see is what you get.
Search JabSto ::

Custom Search