Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1039
  • Last Modified:

Add default reference in excel VBA

If I add a reference to a workbook, that reference will be checked everytime I open that workbook.  But what if I want to add a reference at the application level?  Right now every user in my organization has four references checked by default when they open excel.  What if I want to add one more so the default is five?  How to add a default ref?  Default References
0
atprato
Asked:
atprato
  • 2
1 Solution
 
Michael FowlerSolutions ConsultantCommented:
You could make the change to Book.xlt and then all new workbooks should open with this default

http://office.microsoft.com/en-us/excel-help/customizing-excel-defaults-with-templates-HA001054815.aspx 
0
 
Michael FowlerSolutions ConsultantCommented:
0
 
luconstaCommented:
Another way to do it could be this: Add references programmatically with VB or VBA and putting the code in the PERSONAL.XLS file that could then add the references automatically.

HTH
0
 
NorieVBA ExpertCommented:
Do you need to have this reference in every workbook?

Will all user's actually have access to it?

That last point is quite important - you could add a 'default' reference and it might work fine for most people but there might be others who don't have the version of the particular application the reference is for.

They might not even have the application.

By the way I'm using 'application' as a generic term - I know all references aren't for applications.

Anyway, if they don't have that reference it could play havoc with all the other references and if they've got any code it could stop working.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now