Microsoft Office Tutorials and References
In Depth Information
Linking custom properties to cells
You can link your own custom-built properties to named cells on your worksheet.
When you do, the value of the custom property becomes whatever the named cell
contains and changes whenever the value in the cell changes. First you must name a
cell. (See “Rules for naming” in Chapter 12.) Then click the File tab, click Properties, and
then click Advanced Properties. On the Custom tab in the Properties dialog box,
selecting the Link To Content check box displays the workbook’s defined names in the Value
box (which changes to a drop-down list named Source when linking content), as shown
in Figure 2-31.
Figure 2-31 Use named cells to create dynamic properties based on worksheet cells.
Select or create a name for the custom property in the Name box. (The Type
dropdown list becomes unavailable when you’re linking to content.) When you’ve specified
a source (the named cell to which you want to link), click Add, and the custom property
appears in the Properties list.
If the link is broken (the defined name is later deleted, for example), the Properties
dialog box stores the last value recorded for that property.
If the name defines a range of cells, only the value in the cell in the upper-left corner of
the range appears as the property value.