You can add controls and drawing objects to a worksheet by using the Вставка Элемент управления and Вставка Графический объект menu options. After selecting the menu option, drag the pointer across the worksheet to define the area that the control will occupy. A dialog box will then be displayed that allows you to specify the attributes of the object.
To edit a control or drawing object, press the Ctrl key (on the keyboard) and then click on the object. This will select the object. Then you can use the Правка Удалить menu option or the Формат Элемент управления or Format Графический объект menu option, or you can drag the control to a different position or you can change the shape or size by dragging the border of the object. To deselect a selected object, press the Ctrl key and click on the object again, or select a different object, or click elsewhere on the worksheet. You can also use Tab or Shift+Tab to select the next or previous object.
The following control object types are supported:
| Метка | A text label. |
| Окно группы | A rectangle with an optional heading. Useful for grouping separate sets of option buttons together. |
| Кнопка | A button that can be pressed. Useful for activating a macro. |
| Флажок | A box that can be ticked or unticked. It can return a value of TRUE or FALSE to a linked cell to indicate its state. |
| Перекл | Usually one of a group of buttons that selects one of several items. Only one of the buttons in a group can be pressed at any one time. Use a group box object to define a button group. The group of buttons can return a value to a linked cell indicating the number of the button in the group that is currently pressed. |
| Окно списка | Displays a list of items from a range in the spreadsheet. It can return the number of the selected item to a linked cell. |
| Раскр список | Displays one of a list of items from a range in the spreadsheet. It can return the number of the selected item to a linked cell. |
| Полоса прокр | A horizontal or vertical scroll bar. The orientation is determined by the shape of the rectangle when the control is first inserted. It can return the value of the current position to a linked cell. |
| Рег счетчика | A vertical spin control. It can return the current value to a linked cell. |
The following drawing object types are supported:
| Линия | A line or arrow. |
| Прямоуг | A rectangle that can be filled. |
| Овал | An oval that can be filled. |
| Подпись | A rectangle that can contain text. |
All of the objects can have a macro attached that will be run when the object is clicked on.