To edit the Workbook Dependencies Options:
- Click Edit to open the Workbook Dependencies Options dialog box.
- You may select which elements will be displayed in the Dependencies List. Check or uncheck the Type, Weight, Cost, Annotation column, Annotation box and Add, Edit and Remove buttons checkboxes to view or hide these elements on the list.
Note: If the default dependency column names were changed by inserting labels in the General Dependency Options dialog box, the label names will appear instead of Type, Weight and Cost. :
- In the Item Properties area, select the scorecard that will be used for the Item Properties columns in the Dependencies List from the drop-down list.
When selecting the scorecard consider the following:
- There is a default scorecard called "Workbook Item Properties" specifically defined for this purpose.
- If you select the None option, the Item Properties area of the Dependencies list will disappear and the Dependency Properties area will expand accordingly.
- You may select an existing scorecard or create a new one. Click Edit to change the properties of the selected scorecard. The wizard for the scorecard you selected opens in the Categories step. You may edit the categories (that serve as the Item Properties columns) by clicking Edit. For more information on the Categories step, refer to Defining Scorecard Categories in Working with Scorecards.
- In the Drill-down area, define the label and link of the workbook dependencies drill down.
- Label: enter the text that will appear in the right-click menu of the Workbook module. The default text is "Dependencies".
- Links to: there are two options for the drill-down:
Workbook: if selected, the Workbook module will be the default location to view dependencies.
Form: if selected, Forms will be the default module in which to view dependencies. Select the Form and Tab from the corresponding drop-down lists. This option adds flexibility as you can add data fields around the dependencies list, or provide the ability to add descriptions.
Note: You would customize the default dependencies drill down because:
- Some users are accustomed to working with Forms.
- Not all users use the Workbook. In fact, some users can't even access the Workbook!
- Users may want to display additional information near the dependencies using the special capabilities of a form.