Workbook.AddToFavorites Method

Excel Developer Reference

Adds a shortcut to the workbook or hyperlink to the Favorites folder.

Syntax

expression.AddToFavorites

expression   A variable that represents a Workbook object.

Example

This example adds a shortcut to the active workbook to the Favorites folder.

Visual Basic for Applications
ActiveWorkbook.AddToFavorites

See Also

• Workbook Object
• Workbook Object Members