Microsoft Office Tutorials and References
In Depth Information
Customizing the Display
What’s new in the Visual Basic Editor?
Nothing.
Most of Excel 2010’s updated object model is accessible in your VBA code, but the VB Editor
hasn’t changed in many versions. The Microsoft Office applications all use the new Ribbon UI,
but the VB Editor still uses menus and toolbars. By comparison, most would agree that the VB
Editor is starting to look very old-fashioned. Maybe we’ll see an updated UI in the next release.
But I’m not holding my breath.
Figure 2-13: Locating clipart is one of several uses for the task pane.
Customizing the Display
Excel offers a great deal of flexibility regarding what is displayed on-screen (formula bar,
gridlines, row and column headings, and so on). These commands are located in the View tab.
In fact, Excel makes it possible to develop an application that doesn’t even look like a
spreadsheet. For example, by choosing View➜Workbook Views➜Full Screen, you can get rid of
everything except the title bar, thereby maximizing the amount of information visible. To exit
full-screen mode, right-click any cell and choose Close Full Screen from the shortcut menu.
Notice the zoom control in the right side of the status bar. This control makes zooming in or out
very easy. In addition, you can right-click the status bar and specify the type of information you’d
like to see.
 
Search JabSto ::




Custom Search