xl2003 unchecks VBA Editors references

[cfsmike]

hi

I use a proprietry piece of software called @risk. This interfaces very well with Excel, including some libraries/dll's which are checked/linked via the Tools, References in the VBA editor. Problem: Every time I restart Excel, Excel unchecks the libraries references. How do I get Excel to permanently reference these libraries? In different words, how do I "hardcheck" a link to a dll?

Please note that I do not have admin rights over this machine and would prefer to know how to do this without having to get someone with admin rights to log into this machine.

Cheers from Manchester, UK

Mike

 

[RoryA]

References are workbook-specific, not application-wide. If you want these references set for all workbooks, you would need to create a blank workbook, set the references, then save that as book.xlt in your XLSTART directory.

 

[cfsmike]

Thanks a lot for that. That works for new books.

How do I set a template for existing workbooks? I want to ensure that this library link is checked when I start Excel (which may be either from the start menu or when I directly open a workbook).

Thanks again, Mike

 

[RoryA]

You can't - there is no default way of applying it for existing workbooks, other than code.