Export (0) Print
Expand All
Expand Minimize

SortKey Cell (Hyperlinks Section)

Office 2007

A number that determines the order of hyperlinks that appear on a shortcut menu.

Remarks

The hyperlinks on a shortcut menu appear on the menu sorted from lowest to highest, with lower numbers appearing at the top of the menu. If two hyperlink rows have the same SortKey cell value, the order is determined by physical row order. The default is 0 (zero).

To get a reference to the SortKey cell by name from another formula, or from a program using the CellsU property, use:

Cell name:

Hyperlink.name.SortKey
where Hyperlink.name is the row name

To get a reference to the SortKey cell by index from a program, use the CellsSRC property with the following arguments:

Section index:

visSectionHyperlink

Row index:

visRow1stHyperlink + i
where i = 0, 1, 2...

Cell index:

visHLinkSortKey



Community Additions

ADD
Show:
© 2014 Microsoft