Microsoft Office Tutorials and References
In Depth Information
Figure 1-7: Objects on a worksheet drawing layer. Excel makes a great doodle pad.
You can insert a number of different controls on a worksheet. These controls come in two flavors — Form con-
trols and ActiveX controls. Using controls on a worksheet can greatly enhance the worksheet's usability — of-
ten without using macros. To insert a control, choose Developer ⇒ Controls ⇒ Insert. Figure 1-8 shows a work-
sheet with various controls added to the drawing layer: a check box, two sets of option buttons, and a scroll bar.
The Ribbon's Developer tab is not visible by default. To show the Developer tab, right-
click the Ribbon and choose Customize the Ribbon to display the Excel Options dialog
box. In the list box on the right, place a check mark next to Developer.