Workbook.AddToFavorites Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

expression .AddToFavorites

expression A variable that represents a Workbook object.

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

ActiveWorkbook.AddToFavorites
Show:
© 2016 Microsoft