Customizing and managing controls on a spreadsheet
You can change both the border color and border width of a form control. You can also change the label of a form control to better describe its role in the spreadsheet.
When you add a form control to a spreadsheet, Quattro Pro assigns it a default object name in the format ControlName1, ControlName2, and so on. The default object name is the control label.
For controls that do not have labels (list boxes, combo boxes, scroll bars, and spin controls), you can add a label beside the original control.
The object name is the name used to reference the form control in macros, link commands, and in spreadsheet functions. You can change the object name of a form control the same way you change the object name of other OLE objects.
You can enable protection on a form control. Enabling protection prevents a control from being changed or deleted by other users when protections have been set higher up at the sheet level. For information about protecting spreadsheets and cells, see “Protecting data.”
You can print a spreadsheet without printing a form control.
To change the border of a form control |  |
|
1.
|
|
Select a form control.
|
|
2.
|
|
Right-click the control, and click Properties.
|
|
3.
|
|
Click the Border color tab.
|
|
4.
|
|
Click a color on the color palette.
|
|
5.
|
|
Click the Box type tab.
|
|
6.
|
|
Enable a Box type option.
|
|
If you want to create a shadow behind the control, enable the Drop shadow check box.
|
To change the label of a form control | |
|
1.
|
|
Select a form control.
|
|
2.
|
|
Right-click the control, and click Properties.
|
|
3.
|
|
Click the Label text tab.
|
|
4.
|
|
Type a new label in the Enter text box.
|
To add a label beside a form control | |
|
1.
|
|
Click Insert
 Form control Label text. |
|
2.
|
|
Drag the label to a spot near a form control.
|
|
3.
|
|
Right-click the label, and click Properties.
|
|
4.
|
|
Click the Label text tab.
|
|
5.
|
|
Type a label in the Enter text box.
|
|
•
|
|
To create a control of the default size, put the cursor in the desired position and click once.
|
To change the object name of a form control | 
topproc.gif" alt="Back to Top" border="0" height="10" width="10"> |
|
1.
|
|
Select a form control.
|
|
2.
|
|
Right-click the control, and click Properties.
|
|
3.
|
|
Click the Object name tab.
|
|
4.
|
|
Type a new name in the Object name box.
|
To enable protection on a form control | |
|
1.
|
|
Select a form control.
|
|
2.
|
|
Right-click the control, and click Properties.
|
|
3.
|
|
Click the Protection tab.
|
|
4.
|
|
Enable the Locked check box.
|
To print a spreadsheet without printing a form control | |
|
1.
|
|
Select a form control.
|
|
2.
|
|
Right-click the control, and click Properties.
|
|
3.
|
|
Click the Print tab.
|
|
4.
|
|
Disable the Print object check box.
|