Try something like
Sub AddVbIdeRef()
ThisWorkbook.VBProject.References.AddFromGuid _
GUID:="{0002E157-0000-0000-C000-000000000046}", _
major:=0, minor:=0
End Sub
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
"Harley" wrote in message
...
Is it possible to select a reference via code? Specifically, I'd like to
select "Microsoft Visual Basic for Applications Extensibility.