Adding a default reference

[R Avery]

Whenever a new workbook is created, several references are included by
default ("Visual Basic for Applications", "OLE Automation", etc.). How
would I add a particular reference to, by default, be included as well
(e.g., "Microsoft Scripting Runtime")?

 

[Chip Pearson]

Create a template called Book.xlt with the reference in place,
and save that template in your XLStart folder.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[R Avery]

Thanks!