Workbook.AddToFavorites Method (Excel)
Adds a shortcut to the workbook or hyperlink to the Favorites folder.
Syntax
식 .AddToFavorites
식 A variable that represents a Workbook object.
Example
This example adds a shortcut to the active workbook to the Favorites folder.
ActiveWorkbook.AddToFavorites