You need to go to the Tools menu, choose Macros, then Security.
In that dialog, choose the Trusted Sources tab, and check the
"Trust access to Visual Basic project" setting.


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


"Nick Hebb" wrote in message
oups.com...
Thanks again Chip.

I get a "programmatic access not trusted" error on this line:

Set TLInfo_XL =
TLApp.TypeLibInfoFromFile(ThisWorkbook.VBProject.R eferences("EXCEL").FullPath)

I'm don't know a great deal about security settings, so someone
sharper
could probably find a way around it.

It didn't matter, though since the new version was fully
populated.

Nick Hebb
BreezeTree Software, LLC
http://www.breezetree.com