AddToFavorites Method

Microsoft Excel Visual Basic

AddToFavorites Method

       

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

expression.AddToFavorites

expression   Required. An expression that returns a Workbook or Hyperlink object.

Example

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

ActiveWorkbook.AddToFavorites